Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Oracle - SQL - Sequence - Using a Sequence in a Table Column - Prior to Oracle 12c ======

Prior to Oracle 12c, a sequence can only be associated indirectly with a table column at the insert time.

----

===== Create a new table =====

<code sql>
CREATE TABLE test (
  id NUMBER PRIMARY KEY,
  title VARCHAR2(255) NOT NULL
);
</code>

----

===== Create a Sequence for the id column of the test table =====

<code sql>
CREATE SEQUENCE test_id_seq;
</code>

----

===== Insert data into the test table =====

<code sql>
INSERT INTO test(id, title)
VALUES(test_id_seq.NEXTVAL, 'A Sequence Value');

INSERT INTO test(id, title)
VALUES(test_id_seq.NEXTVAL, 'Another Sequence Value');
</code>

----

===== Query data from the test table =====

<code sql>
SELECT id, title
FROM test;
</code>


<WRAP info>
**NOTE:**  The test Table has no direct association with the test_id_seq sequence.
</WRAP>