SQL Server to Oracle for developers…

I get a number of questions from developers who are used to working with SQL Server, but have recently moved to Oracle. The top 2 issues are:

  • Lack of AutoNumber/Identity columns in Oracle (solution).
  • How to return recordsets from stored procedures (solution).

Recently I had a question about how you return the value assigned by a sequence during a DML statement, either directly or when using a trigger to populate the sequence value. The one option is the RETURNING INTO clause, but I checked my site and couldn’t find an example of it to direct them too, so I wrote one (here). :)



Published by


I DBA, Developer, Author, Trainer.