Home » SQL & PL/SQL » SQL & PL/SQL » using sequence in default clause for a column
using sequence in default clause for a column [message #128] Wed, 16 January 2002 15:39 Go to next message
k
Messages: 12
Registered: July 1999
Junior Member
Why cant u use sequences in the default clause of a column, what is the best workaround 2 providing this functionality??? ie trigger
Re: using sequence in default clause for a column [message #134 is a reply to message #128] Thu, 17 January 2002 02:12 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

A default expression can not contain references to other columns,pseudocolumns CURRVAL,NEXTVAL,LEVEL,ROWNUM,or date constants that are not fully specified.

Use trigger to achieve the same.

cheers
pratap
Previous Topic: txt
Next Topic: Re: how to pass parameters dynamically
Goto Forum:
  


Current Time: Mon Apr 06 04:55:36 CDT 2020