Creating Multiple Rows at 1 Time

BrianWren · February 22nd, 2008, 01:37 PM

This was ineffective:

Code:

     SQL>INSERT INTO DISFIN_NO_SHOW (DOCN)
       2 VALUES                     ('X1', 'X2', 'X3');
     INSERT INTO DISFIN_NO_SHOW (DOCN)
                 *
     ERROR at line 1:  ORA-00913: too many values

But I know that multiple rows can be created with

Code:

     INSERT INTO DISFIN_NO_SHOW (DOCN)

Code:

     SELECT DOCN||'X'
     FROM   DISFIN_NO_SHOW
     WHERE  DOCN > '12345';

How can I provide values to the SQL, and create a group of rows at a time as the SELECT statement would do?