[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