[thelist] Oracle SQL

Mark M mark at safefrombees.com
Mon Feb 9 20:50:45 CST 2004

You don't have 'auto_number' as you would inside access or mySQL.

This is handled instead by 'sequences' in Oracle.

A good tute can be found here:

If you have any more questions, feel free to ask.

mark at safefrombees.com
ICQ: 3094740
Safe From Bees
[ www.safefrombees.com ]

Quoting Mary <destiny_mp at hotmail.com>:

> 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 !

More information about the thelist mailing list