Re: Hello, a question comparing sql server to Oracle

In Oracle, you'll want to create a sequence and then create a trigger on your table to generate the next value from a sequence and insert that value in the table's column.

In SQL Server, the autoincrementing column value is tied directly to the table. In Oracle, the sequence is not directly tied to anything...

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown