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

RogBaker_at_gmail.com wrote:
> 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.

Hi,

Thank you for your response. I am going to try your scripts tomorrow in our BUILD environment.

Crystal Received on Thu Jan 18 2007 - 15:39:50 CST