Skip to content Skip to sidebar Skip to footer

Insert Into Table Using Result Set Of Dual Query?

I have a table, edgar_t100 and which is a table of one column, named ID. I need it to have 100 rows where each row/column intersection is just the number of the row. Obviously I do

Solution 1:

Try this way:

insert into edgar_t100 (col1) 
select rownum as ID 
from dual 
connect by rownum <= 100

Post a Comment for "Insert Into Table Using Result Set Of Dual Query?"