Re: Auto incrementing key

chanakam2000_at_gmail.com wrote:
> Hi,
>
> Please help me,
>
> I'm new to oracle environment.
> I want to make a kind of auto generated primary key for my table.
> I can make auto key with sequences and triggers. But only numeric
> keys
> But i want the key with some character value.
>
> Ex : for student_id column my preffered value sequence is
>
> S-00001
> S-00002
> S-00003 ..... & so on
>
> I searched lot in internet. But could not find goood solution.
> Please give me some idea.
>
> If this is not possible please give me idea to generate sequence like
> 00001,00002,00003....
>
> By using sequence i could only generate 1,2,3 & not 000001 ..etc
>
> If you don't mind please emil me to chanakam2000_at_gmail.com or else
> please answer to this group. I can visit.
>
> Hoping your kind help!

Oracle is NOT a Microsoft product and you MUST read the docs.

Oracle uses an object type named SEQUENCE for this purpose. Go to Morgan's Library at www.psoug.org and you will find working demos.

BTW: It is very very bad form to ever create a key of the type 'S-00001' you demonstrate above. Don't do it. If you need the "S" put it into a separate column and leave out the hyphen.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)