Home » SQL & PL/SQL » SQL & PL/SQL » creating auto generation column
creating auto generation column [message #230780] Thu, 12 April 2007 15:21 Go to next message
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
hello sir

Actually i have two tables ,i explain with examples below

>create table test1 (id number(5) primary key,name varchar2(40))

>create table test2 (id number(5),eno number(10),constraint foreign key fk_id(id) references test1(id)

i want to create auto generated column for id using sequence for both test1 and test2 table with parent child relationship .

plz help how can i do this
Advanced thank u.
Re: creating auto generation column [message #230827 is a reply to message #230780] Fri, 13 April 2007 00:57 Go to previous message
Michel Cadot
Messages: 64620
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As this is a question that is posted hundred times in the last 10 years I participed in forums, I think you should find the answer with qui a quick search.

Previous Topic: trying to get percentage of count
Next Topic: Environment variables
Goto Forum:

Current Time: Wed Mar 29 10:14:09 CDT 2017

Total time taken to generate the page: 0.11971 seconds