OraFAQ Forum: SQL & PL/SQL » using sequence in default clause for a column

Home » SQL & PL/SQL » SQL & PL/SQL » using sequence in default clause for a column

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

using sequence in default clause for a column [message #128]

Wed, 16 January 2002 15:39

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

Report message to a moderator

Re: using sequence in default clause for a column [message #134 is a reply to message #128]

Thu, 17 January 2002 02:12

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

Report message to a moderator

Previous Topic:	txt
Next Topic:	Re: how to pass parameters dynamically

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 07 17:11:45 CDT 2023