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: http://www.llcsystems.com/FAQ/oracle_SQL/oracle_SQL_14.htm If you have any more questions, feel free to ask. Mark ------------------------------------------------------------------ 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 ! > > >