This is an SQL Query which would create a variable table and inserts sequence of numbers into the table.
declare @months table(Month int identity (1,1))
declare @i int set @i = 0
while(@i<3)
begin
insert @months default values
set @i = @i + 1
end
I need this same query in Oracle. Can anyone help me in this.
Any solution would be appreciated.
Thanks,
Vasuki
declare @months table(Month int identity (1,1))
declare @i int set @i = 0
while(@i<3)
begin
insert @months default values
set @i = @i + 1
end
I need this same query in Oracle. Can anyone help me in this.
Any solution would be appreciated.
Thanks,
Vasuki