Auto incrementing key

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! Received on Sun Apr 09 2006 - 12:23:06 CDT