September
26th
2007

Create auto increasement column in Oracle

Technology No Comments 0 view(s)

评分： 很差劲不怎样还可以还不错太棒了
Loading ... Loading ...
First let’s create a simple table to play with.
  1. SQL> CREATE TABLE test (id NUMBER PRIMARY KEY, name VARCHAR2(30));

Table created.

Now we’ll assume we want ID to be an auto increment field.
First we need a sequence to grab values from.

  1. SQL> CREATE SEQUENCE test_sequence
  2. START WITH 1
  3. INCREMENT BY 1;

Sequence created.