Re: Unique Column in Oracle 7.3

Daniel Noelte wrote:
>
> A real automatic is not available. Use sequences for generate unique primary
> keys.
>
> Daniel
>
> Ian Douglas wrote:
>
> > I am an Oracle newbie. Could someone please tell me how to create a
> > column with in an Oracle Table that has an automatically unique
> > sequential number. I have looked at the rowid column, but this is no
> > good to me because I need to specify the column name.

You can use a BEFORE INSERT FOR EACH ROW trigger to automate such unique key generation from a sequence.

Borivoj Tydlitat
btydlitat_at_merin.cz Received on Wed Sep 24 1997 - 00:00:00 CDT