Adding a sequence number adder to an Insert statement 1

[diehippy]

Hi all,

I have currently written an insert statement that brings details from couple of tables into another table, the question if someone could please help me with is that the table that I am inserting the new rows into has a sequence id number that is growing by one each time a new entry is added to the table. What would be the best SQL statement that I need to use to increase the sequence id number when I use my insert statement?

Many Thanks in advance for help

Diehippy

 

[jimirvine]

You would use the NEXTVAL method of the sequence. You can find this info in the fine documentation at

http://tahiti.oracle.com.

Note, a sequence will NOT guarantee gapless values.

 

[diehippy]

Thanks Jimirvine,

that worked really well no gapless values

Cheers

Diehippy