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

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;

INSERT INTO test(id, title)
VALUES(test_id_seq.NEXTVAL, 'Create a Test Sequence');
 
INSERT INTO test(id, title)
VALUES(task_id_seq.NEXTVAL, 'Check Sequence Values');

SELECT id, title
FROM test;