Though no logical relationship is available in Oracle between a sequence
and a sole column to which it is intended to be assigned, at times such
a relationship can be useful. An example is in an application that
walks any schema and automatically generates a GUI on the fly to provide
a RAD front-end (one of my development ventures). To accomodate a
pseudo-logical link between a sequence and a table column, assign the
table column's comment to either the name of the sequence (guaranteed to
be unique), or the sequence system identifier.
Best of luck!
Received on Fri Jul 16 1999 - 23:57:42 CDT
