Path: news.easynews.com!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!oleane.net!oleane!freenix!deine.net!fu-berlin.de!uni-berlin.de!adsl-133-52.init7.NET!not-for-mail From: Rene Nyffenegger Newsgroups: comp.databases.oracle.server Subject: Re: How can I ceate a table primary key that auto increase by itself like access table id key ? Date: 3 Mar 2003 16:42:25 GMT Organization: NetArchitects Lines: 22 Message-ID: References: NNTP-Posting-Host: adsl-133-52.init7.net (213.144.133.52) X-Trace: fu-berlin.de 1046709745 61017936 213.144.133.52 (16 [82536]) User-Agent: slrn/0.9.7.4 (Win32) Xref: newsfeed1.easynews.com comp.databases.oracle.server:178274 X-Received-Date: Mon, 03 Mar 2003 09:42:18 MST (news.easynews.com) > How can I ceate a table primary key that auto increase by itself like access > table id key ? > Is there any nature support on Oracle ? This question has many, many times been answered here. Use groups.google.com and search for oracle, autonumber, trigger and sequence See also http://makeashorterlink.com/?Y33435A63 hth Rene Nyffenegger -- no sig today