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).