insert multiple values into a single column

[Romeo Ranjan]

Hi all,

I want to insert eight values(rows) into a single column of my table.How do i do that??

This INSERT statement allows to insert a single record or multiple records into a table.

INSERT INTO table
(column-1, column-2, ... column-n)
VALUES
(value-1, value-2, ... value-n);

but what i want is

INSERT INTO table
(column-1)
VALUES
(column-1value1,column-1value2,column-1value3,...,column-1value8);

How do i go about doing this??
Trying this format

SQL> insert into test sal values
  2  (1000),
  3  (1001),
  4  (1002),
  5  (1003),
  6  (1004),
  7  (1005),
  8  (1006),
  9  (1007)
 10  ;
(1000),
      *
ERROR at line 2:
ORA-00933: SQL command not properly ended

or

SQL>  insert into test sal values
  2  (1001,1002,1003,1004,1005,1006,1007,1008);
 insert into testhib sal values
             *
ERROR at line 1:
ORA-00913: too many values

gives me the following error.

[Sona Patel]

Hi Ranjan,

You will have to write different insert statements for all column values as below..

    
INSERT INTO table (column-1)  VALUES  (value-1);
INSERT INTO table (column-1)  VALUES  (value-2);
----
INSERT INTO table (column-1)  VALUES  (value-n);