Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Auto increment with a prefixed letter

468183Feb 1 2006 — edited Feb 2 2006
Hi all, I've read numerous threads about getting an auto incremented column using Sequences and Triggers. I have a few short questions:

1) If my primary key has a prefixed letter followed by numbers e.g. C00001, can I get it to auto increment the numbers using the Sequence/Triggers route ?

2) I am using datatype CHAR for the primary key to accomodate the prefixed letter, is there a special trick that I could use to get the prefixed single letter but use datatype NUMBER for the primary key ?

3) Regarding Sequences and Triggers, data will be input using Oracle Forms, can I set up the Sequences and Triggers for the auto incremented column while creating my Forms - inside the Forms Builder ?

Thanks in advance

Kevin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2006
Added on Feb 1 2006
9 comments
3,257 views