Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to define a pseudo auto value column in oracle?

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

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 8 Feb 2005 12:00:41 -0500
Message-ID: <pd6dnZ0zquCjbZXfRVn-iw@comcast.com>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US