Insert row number

[siva125]

i use row_number() in my sql query to generate number from 1...,but i need to start with row number from 100,101 like wise i using sql4.2 navigator ,i use auto increment it show error what to do


insert into ideal_ctry(sele ct row_number() over (order by description asc)) as ncode

but i need start with 100,101...

[amitpatel66]

Create and use Oracle Sequence

[siva125]

thank u .but i did rownum+99 in select command itself it working

[debasisdas]

if that is working , what is the problem than ?

[OraMaster]

Can you post the SQL where you have used ROWNUM since the SQL you used earlier using ROW_NUMBER() seems wrong anyway.