how to know on which column,the sequence is applied?

Posted by Vineet on Stack Overflow See other posts from Stack Overflow or by Vineet
Published on 2010-06-17T17:42:27Z Indexed on 2010/06/17 23:03 UTC
Read the original article Hit count: 173

Filed under:
|
|
|

I have to fetch all sequences with their table name along with the column name on which sequence is applied .Some how i managed to fetch table name corresponding to sequence because in my data base sequence is stored with first name as table name from data dictionary(all_sequences and all_tables) .

Please let me know how to fetch corresponding column name also if possible!!

© Stack Overflow or respective owner

Related posts about sql

Related posts about Oracle