Sequence Name [message #289441] |
Fri, 21 December 2007 13:24  |
velav
Messages: 1 Registered: December 2007 Location: USA
|
Junior Member |
|
|
Hi,
My Requirement is I know the Table and column name and need to find Is sequence is created for that table or not.. if so need to find the sequence name.
Pls help me out to find the same. DBA_SEQUENCES, ALL_SEQUENCES doesnt helped me out to get these stuffs.
Thanks and Regards,
Velav
|
|
|
|
|
Re: Sequence Name [message #289445 is a reply to message #289444] |
Fri, 21 December 2007 13:47  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Quote: | A sequence is "bound" to a table only by some code in any trigger on that table.
|
A small correction: ...may be "bound"...
There are a lot of applications where this "bind" is done in program code (either PL/SQL or external one).
Regards
Michel
|
|
|