Click here to Skip to main content
15,885,278 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i want to populate one table using sequence of numbers.

What I have tried:

SQL
insert into emp
select start_value+1 from city_city_id_seq


if this query executes 10 times it should insert
1,2,3,4,5,6 in a incremental method

here city_city_id_seq is sequence i have created.but it is not giving icremental value or sequence value how to do that please tell me
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900