Need an query in Oracle equivalent to SQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Vasuki Masilamani
    New Member
    • Dec 2006
    • 18

    Need an query in Oracle equivalent to SQL

    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
Working...