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: 65155
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: download a pdf file from long raw
Next Topic: ORA error with object no longer exists
Goto Forum:

Current Time: Wed Aug 23 16:39:52 CDT 2017

Total time taken to generate the page: 0.13381 seconds