Autogenerated values.. [message #9929] |
Mon, 15 December 2003 01:18 |
resy
Messages: 86 Registered: December 2003
|
Member |
|
|
HI all,
Is there any way to know that , which all fields in a table holds auto generated values?
for eg:
SQL> desc test_AUTO;
Name Null? Type
--------------------- -------- --------------------
VV NUMBER(10)
actually while inserting value to VV imj using sequence.
Here i know that VV is autogenerated.
But if i know only the structure of a table.How can i know that how many fields in that table holds autogenerated values??
thanx.
|
|
|
Re: Autogenerated values.. [message #9933 is a reply to message #9929] |
Mon, 15 December 2003 03:57 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
Not just from the table structure. Note that Tables and Sequences are independent objects. A sequence can be used to insert values into any table and a table can be updated with different sequences.
Generally surrogate primary keys(or candidate keys) are generated through sequence,but again you will need to know that(sql code(inserts,triggers etc).
In one session I can update a table through a sequence and in another, supply the values explicitly ...
-Thiru
|
|
|