Auto-increment in Oracle without using a trigger

by

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

More Related Contents:

  1. Oracle trigger after insert or delete
  2. HIbernate issue with Oracle Trigger for generating id from a sequence
  3. Trigger to enforce M-M relationship
  4. Why is the GETDATE() an invalid identifier
  5. ORA-04091: table [blah] is mutating, trigger/function may not see it
  6. How to create id with AUTO_INCREMENT on Oracle?
  7. Calculate difference between 2 date / times in Oracle SQL
  8. Can you SELECT everything, but 1 or 2 fields, without writer’s cramp?
  9. How to generate entire DDL of an Oracle schema (scriptable)?
  10. How to handle Day Light Saving in Oracle database
  11. How to get records randomly from the oracle database?
  12. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  13. Auto Increment for Oracle
  14. Get resultset from oracle stored procedure
  15. Deploying and Configuring ODP.NET to work without installation with Entity Framework
  16. Add a auto increment primary key to existing table in oracle [duplicate]
  17. ways to avoid global temp tables in oracle
  18. Spring Batch ORA-08177: can’t serialize access for this transaction when running single job, SERIALIZED isolation level
  19. Number of rows affected by an UPDATE in PL/SQL
  20. PL/SQL print out ref cursor returned by a stored procedure
  21. Dynamically pivoting a table Oracle
  22. Spool Command: Do not output SQL statement to file
  23. Is there any way to have the JBoss connection pool reconnect to Oracle when connections go bad?
  24. Get ID of last inserted record in oracle db
  25. oracle SQL plus how to end command in SQL file?
  26. Get the number of days between two dates in Oracle, inclusive of the dates
  27. How to output result of SELECT statement which is executed using native dynamic SQL?
  28. How to use parameters in a ‘where value in…’ clause?
  29. How to generate a version 4 (random) UUID on Oracle?
  30. Find out the history of SQL queries

Leave a Comment