Oracle Sql : create column/table with a for loop

Question

I want to create a table with a column that will hold integer values from 1 to 2000.

Then I want insert records into the table with each value (1,2,3,...,2000).

I tried using a for loop to do so, but I don't succeed.

Can someone help me ?'

Thanks

Your intentions are not quite clear. And where are all your attempts? Code please. — Nick Krasnov
– Nick Krasnov, Commented May 19, 2015 at 21:02
possible duplicate of Oracle 11g - FOR loop that inserts only weekdays into a table? — Cwt
– Cwt, Commented May 19, 2015 at 21:05

krokodilko · Accepted Answer · 2015-05-19 21:21:21Z

2

Try:

CREATE TABLE mytable AS
SELECT level AS columnname FROM DUAL
CONNECT BY LEVEL <= 2000;

answered May 19, 2015 at 21:21

krokodilko

36.3k7 gold badges62 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1