Message-Id: <25937.338109@fatcity.com> From: "Stephane Paquette" Date: Wed, 16 Jul 2003 14:36:52 -0400 Subject: RE: Find the table's name that using sequences This is a multi-part message in MIME format. ------=_NextPart_000_0093_01C34BA7.B2AF4B40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit MessageYou must look in the code... I've not played much with Oracle 9i, is there such a thing as the identity column like in DB2, Sybase, Sql Server ? Maybe in 10i ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 stephane.paquette@standardlife.ca -----Original Message----- From: ml-errors@fatcity.com [mailto:ml-errors@fatcity.com]On Behalf Of Mitchell Sent: Wednesday, July 16, 2003 3:09 PM To: Multiple recipients of list ORACLE-L Subject: Find the table's name that using sequences Hi All At first I thought it is easy to find those tables to use sequences but I failed. dba_sequence don't give too much info. Is there any idea? Thanks in advance Mitchell ------=_NextPart_000_0093_01C34BA7.B2AF4B40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message
You=20 must look in the code...
 
I've=20 not played much with Oracle 9i, is there such a thing as the identity = column=20 like in DB2, Sybase, Sql Server ?
Maybe=20 in 10i ? 
 

Stephane = Paquette

Administrateur=20 de bases de donnees

Database=20 Administrator

Standard=20 Life

www.standardlife.ca

Tel.=20 (514) 499-7999 7470 and (514) 925-7187

stephane.paquette@stand= ardlife.ca


 -----Original = Message-----
From:=20 ml-errors@fatcity.com [mailto:ml-errors@fatcity.com]On Behalf Of=20 Mitchell
Sent: Wednesday, July 16, 2003 3:09 = PM
To:=20 Multiple recipients of list ORACLE-L
Subject: Find the = table's name=20 that using sequences

Hi All
 
At first I thought it is easy to find those tables = to use=20 sequences but I failed.  dba_sequence don't = give too=20 much info.  Is there any idea?
 
Thanks in advance