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?"