Re: How to know what sequence a table is using?

cyc73 wrote:
>...Do you know what cause the number to jump?

To find what sequence the table might be using, is would do something like:
SELECT SQL_TEXT FROM V$SQL where SQL_TEXT LIKE '%MYTABLENAME%' and SQL_TEXT like '%NEXTVAL%'

That might show you an insert statement into your table and the sequence name should preface .NEXTVAL.

As far as your other question, another process might be using the same sequence for another table, thus incrementing it seperately. Also, it is possible to alter the nextval or increment of the sequence. Received on Thu Jan 18 2007 - 10:29:07 CST