RE: Find the table's name that using sequences

From: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Wed, 16 Jul 2003 14:36:52 -0400
Message-Id: <25937.338109@fatcity.com>

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_at_standardlife.ca

   -----Original Message-----
  From: ml-errors_at_fatcity.com [mailto:ml-errors_at_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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2726.2500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><SPAN class=3D994063518-16072003><FONT face=3DArial color=3D#0000ff =
size=3D2>You=20
must look in the code...</FONT></SPAN></DIV>
<DIV><SPAN class=3D994063518-16072003><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D994063518-16072003><FONT face=3DArial color=3D#0000ff =
size=3D2>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 ?</FONT></SPAN></DIV>
<DIV><SPAN class=3D994063518-16072003><FONT face=3DArial color=3D#0000ff =
size=3D2>Maybe=20
in 10i ?</FONT> </SPAN></DIV>
<DIV><SPAN class=3D994063518-16072003><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D994063518-16072003>
<DIV>
<DIV>
<H2 style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DFR-CA=20
style=3D"FONT-SIZE: 12pt"><EM><FONT face=3DArial>Stephane = Paquette<?xml:namespace=20
prefix =3D o ns =3D "urn:schemas-microsoft-com:office:office"=20 /><o:p></o:p></FONT></EM></SPAN></H2>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DFR-CA=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt; mso-ansi-language: FR-CA">Administrateur=20 de bases de donnees</SPAN></P>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DFR-CA=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt; mso-ansi-language: FR-CA">Database=20 Administrator</SPAN></P>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt">Standard=20
Life<o:p></o:p></SPAN></P>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DFR-CA=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt; mso-ansi-language: FR-CA">www.standardlife.ca</SPAN><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt"><o:p></o:p></SPAN></P>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DFR-CA=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt; mso-ansi-language: FR-CA">Tel.=20 (514) 499-7999 7470 and (514) 925-7187</SPAN></P>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN lang=3DFR-CA=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt; mso-ansi-language: FR-CA"></SPAN><SPAN=20 lang=3DFR-CA=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 12.0pt; mso-ansi-language: FR-CA; mso-fareast-font-family: 'Times New = Roman'; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><A=20

href=3D"mailto:stephane.paquette_at_standardlife.ca">stephane.paquette_at_stand=
ardlife.ca</A></SPAN></P></DIV></DIV></SPAN></DIV>

<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT = face=3DTahoma><BR><FONT=20
  size=3D2><SPAN class=3D994063518-16072003><FONT face=3DArial=20   color=3D#0000ff> </FONT></SPAN>-----Original = Message-----<BR><B>From:</B>=20
  ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]<B>On Behalf Of=20   </B>Mitchell<BR><B>Sent:</B> Wednesday, July 16, 2003 3:09 = PM<BR><B>To:</B>=20
  Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Find the = table's name=20
  that using sequences<BR><BR></FONT></FONT></DIV>

  <DIV><FONT size=3D2>Hi All</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT size=3D2>At first I thought it is easy to find those tables =

to use=20
  sequences but I failed.  </FONT><FONT size=3D2>dba_sequence don't = give too=20
  much info.  Is there any idea?</FONT></DIV>   <DIV> </DIV>
  <DIV><FONT size=3D2>Thanks in advance</FONT></DIV> Received on Wed Jul 16 2003 - 13:36:52 CDT