Auto increment with a prefixed letter
468183Feb 1 2006 — edited Feb 2 2006Hi 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