Re: Auto incrementing key

<chanakam2000_at_gmail.com> a écrit dans le message de news: 1144603386.437386.216950_at_e56g2000cwe.googlegroups.com...
| 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!
|

I answered you in c.d.o.misc.
Let me give you one more advice: don't multipost on c.d.o.* newgroups. We read all the groups, you don't access more people with a multiposting but you irritate.

Regards
Michel Cadot Received on Sun Apr 09 2006 - 12:59:31 CDT