[thelist] Oracle SQL

Mary destiny_mp at hotmail.com
Mon Feb 9 23:09:13 CST 2004


I need to define a primary key as an autonumber. 

 institution_id  NUMBER(7) NOT NULL
 CONSTRAINT Institution_institution_id_pk PRIMARY KEY (institution_id) 

does not seem to do it.  I can't seem to find any documentation or examples on how to do it using SQLPLUS.


More information about the thelist mailing list