Re: Auto incrementing key


<chanakam2000@xxxxxxxxx> a écrit dans le message de news: 1144603386.437386.216950@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!
|

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


.

Relevant Pages

  • Re: Auto incrementing key
    ... | I'm new to oracle environment. ... | I want to make a kind of auto generated primary key for my table. ... | If this is not possible please give me idea to generate sequence like ...
    (comp.databases.oracle.misc)
  • Re: Auto incrementing key
    ... I'm new to oracle environment. ... I want to make a kind of auto generated primary key for my table. ... If this is not possible please give me idea to generate sequence like ...
    (comp.databases.oracle.misc)
  • Re: auto number vs byte
    ... > beginning I designed the primary key to be number ... > instead of auto number in order to save on resourses and ... > lot more difficult in programming compared to auto number. ... > a more complex routine to handle addition of new items ...
    (microsoft.public.access.formscoding)
  • RE: crosstab or looping statement help
    ... number can appear in multiple counties). ... The primary key is an auto ... The other table (tReview) has another auto number primary key with ...
    (microsoft.public.access.reports)
  • Re: Form Save
    ... You calculate the new value for this Primary Key in the Before Update event ... they get the same calculation. ... Auto Number ... Increment number ...
    (microsoft.public.access.modulesdaovba)
Loading