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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Re: Auto sequencing

Re: Re: Auto sequencing

From: Greg <actiris_at_loxinfo.co.th>
Date: 2000/04/19
Message-ID: <38FD4BE9.CC10450E@loxinfo.co.th>#1/1

Robert
I agree with U
one thing, the sequences work only with numbers, (as far I know) so you have to create a trigger who inserts the "anyKey" + sequences.nextval.
in to the ID field.
Or do you have a other (better) solution. thankx greg

rtproffitt_at_my-deja.com wrote:

>
> Based on this knowledge, I prepared Varchar2 ID columns
> and Stored Functions which called the sequence generator
> for me. In my case, I used two identifiers: plant type,
> and ID Type to create the uniqueness. Thus, a Nextval
> of 123456 became "Long Beach" + "UserID" + NNNNNN
> LBUI123456.
>
>
> Good Luck
> Robert Proffitt
> RTProffitt_at_Beckman.com
> Beckman Coulter
> Brea, California
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Apr 19 2000 - 00:00:00 CDT

Original text of this message

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