Re: Auto incrementing key
- From: "Michel Cadot" <micadot{at}altern{dot}org>
- Date: Sun, 9 Apr 2006 19:56:13 +0200
<chanakam2000@xxxxxxxxx> a écrit dans le message de news: 1144603561.080923.244840@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
| 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@xxxxxxxxx or else
| please answer to this group. I can visit.
|
| Hoping your kind help!
|
As you are new let me give you an advice.
You are surely not the first one to ask yourself such a question
so before posting make a little search on Google you'll surely
find the answer.
Another point, when you post always tell us your Oracle version,
OS name and version. Many answers depend on these parameters.
Regards
Michel Cadot
.
- Follow-Ups:
- Re: Auto incrementing key
- From: chanakam2000
- Re: Auto incrementing key
- References:
- Auto incrementing key
- From: chanakam2000
- Auto incrementing key
- Prev by Date: Auto incrementing key
- Next by Date: Re: Cursor Parameter Problems/Question
- Previous by thread: Auto incrementing key
- Next by thread: Re: Auto incrementing key
- Index(es):
Relevant Pages
|
Loading
