Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

To find sequence for particular column

cubeguyApr 8 2010 — edited Apr 8 2010
Is there any way to find the sequence name for a particular column in table

ex

if empno in emp table uses the sequence empno_seq

so if a created that sequence i would know that empno_seq will be used by empno column.but other users how will they find the sequence name if they don't create one??

i tried some quires but unable to find

SELECT * FROM USER_SEQUENCES WHERE sequence_name = 'emp_seq'

what could be the "last_number" column in above query?? i could not understood what it refers??

Can any one help??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2010
Added on Apr 8 2010
2 comments
2,954 views