[thelist] Oracle SQL

Chris Murtland chris at studiomoxie.com
Mon Feb 9 20:30:15 CST 2004


>From my brief exerience with Oracle, I believe you have to define a sequence for this. Googling for Oracle create sequence should help.

Chris Murtland

> 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.
> --
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/

> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !

--
Studio Moxie
www.studiomoxie.com


More information about the thelist mailing list