Having a sequence, I need to find out which table.column gets its values. As far as I know, Oracle doesn't keep track of this relationship. So, looking up for the sequence in source code would be the only way. Is that right?
Anyone knows of some way to find out this sequence-table relationship?
In the database you can search all stored code in your schema like this:
select type, name, line, text from all_source where owner = 'MYSCHEMA' and upper(text) like '%MYSEQ.NEXTVAL%';
In SQL Developer, there is a report to do this.