Re: how to define a pseudo auto value column in oracle?

From: Norman Dunbar <Norman_at_Dunbar-it.co.uk.REMOVETHIS>
Date: Tue, 08 Feb 2005 16:55:11 +0100
Message-ID: <cuaql1$7k2$2$8300dec7@news.demon.co.uk>

Mark C. Stock wrote:
> "Norman Dunbar" <Norman_at_Dunbar-it.co.uk.REMOVETHIS> wrote in message

<SNIP>

>>Now, you can't use this as the default for a column in a table, but you 
>>don't now have to remember the name of the 'XYZ' sequence either - granted 
>>you do have to remember the name of the function though :o)
>>

<SNIP>

>
>
> create table autonumber ( id number default autovalue(), text varchar2(30) )
> *
> ERROR at line 1:
> ORA-04044: procedure, function, package, or type is not allowed here
>
> :-(
>
> ++ mcs
>
>

Afternoon Mark,

I did write 'Now, you can't use this as the default for a column in a table ....' :o)

I suppose I could have made it clearer that this was simply an exercise in not having to remember the sequence name.

Cheers,
Norm. Received on Tue Feb 08 2005 - 09:55:11 CST