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

"Norman Dunbar" <Norman_at_Dunbar-it.co.uk.REMOVETHIS> wrote in message news:cuaql1$7k2$2$8300dec7_at_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.

ahh! that sounds more like Norm post content quality.

sorry that i missed the ['t]

++ mcs Received on Tue Feb 08 2005 - 11:00:41 CST