Auto-increment in Oracle without using a trigger

oracle triggers auto-increment sequences
Lakshmi picture Lakshmi · Nov 25, 2008 · Viewed 32.7k times · Source

What are the other ways of achieving auto-increment in oracle other than use of triggers?

Answer

Dheer picture Dheer · Nov 25, 2008

You can create and use oracle sequences. The syntax and details are at http://www.techonthenet.com/oracle/sequences.php

Also read the article http://rnyb2.blogspot.com/2006/02/potential-pitfall-with-oracle-sequence.html to understand the limitations with respect to AUTONUMBER in other RDBMS

Related questions

PLSQL :NEW and :OLD

Can anyone help me understand when to use :NEW and :OLD in PLSQL blocks, I'm finding it very difficult to understand their usage.

Read More
ORA-04082: NEW or OLD references not allowed in table level triggers

itI have table named per. In the per table, I have a field named "fl1" and another field named "fl2". When updating a record, I want to check if the value of "fl1" has changed". If the value has changed, …

Read More
pragma autonomous_transaction in a trigger

I have written a trigger on one table which deletes data from other table upon a condition. The trigger has pragma autonomous_transaction, and trigger works as intended. However, I do wonder if there can be any problems in future, …

Read More