Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CREATE SEQUENCE

Praveen Kumar SinghApr 24 2014 — edited Apr 28 2014

1st line got executed very well.

CREATE SEQUENCE order_seq MINVALUE 1 START WITH 1 INCREMENT BY 1 CACHE 20;

2nd line is throwing an error " COLUMN NO ALLOWED". what could be the possible reason.i tried but not able to find it.

CREATE TABLE INVOICE (INVOICE_id NUMBER DEFAULT order_seq.NEXTVAL,Description VARCHAR2(30));

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2014
Added on Apr 24 2014
4 comments
2,063 views