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

Home -> Community -> Usenet -> c.d.o.server -> Re: Generating unique values without triggers/sequences

Re: Generating unique values without triggers/sequences

From: Steve M <steve.mcdaniels_at_vuinteractive.com>
Date: Fri, 19 Jul 2002 16:29:26 -0700
Message-ID: <aha7bt$hn7$1@spiney.sierra.com>


Can you give us an example where a VARCHAR+1 would be meaningful?

"D. Alvarado" <laredotornado_at_zipmail.com> wrote in message news:9fe1f2ad.0207191324.672f59f2_at_posting.google.com...
> Hello,
> (oracle 8.1.7) Due to the seemingly ridiculous restrictions I've
> put on this problem, it may not be possible to do this, but here goes:
> I'm looking for a way (in an INSERT statement) to generate unique
> values for a column either of a numeric or VARCHAR type. If it was
> just numeric, this would be basically straightforward:
>
> MAX(NUMERIC_FIELD) + 1
>
> but writing a more generic version to accommodate VARCHAR is more
> complicated. I discovered "MAX" is supported on VARCHAR's, but sadly,
> "+ 1" is not, for obvious reasons.
>
> Any ideas would be greatly appreciated.
>
> Thanks, Dave A.
Received on Fri Jul 19 2002 - 18:29:26 CDT

Original text of this message

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