Re: sql - question

I think you are mixing apples and oranges here. An oracle sequence can be the source of values which are inserted into a column, but there is never any logical connection between that column and the sequence except insofar as your code uses the sequence to populate the column.

Thus, if you have a statement like this:

insert
into mytable (col1,col2,col3)
values (val1,val2,mysequence.nextval);

and that is the only statement ever used to insert rows into 'mytable' then you can always count on the next value supplied by the sequence to be the next value inserted into the table. But once that happens you cannot ever even logically say that the value in the column was ever supplied by the sequence.

So again, apples and oranges here. The two have no logical connection.

Ken

Marco Toccafondi wrote:

> How can I view the association between a sequence and a column?
>
> Thanks in advice.
Received on Fri Jul 02 1999 - 07:06:05 CDT