Re: ID's in a table

On Sun, 25 May 2003 09:42:31 GMT, "LouisD" <dumontls_at_dumontls.com> wrote:

>I understand that when you create a table the ID column is a numerical
>sequence. How can I get the ID prefixed with a letter every time record is
>saved so the the ID will always have a single pretermined alphabet preceding
>the ID numbers
>
>Thanks in advance.
>
>Louis
>

1 not necessarily
2 Are you saying you intend to change the PK everytime the record is saved? You don't mean this!
3 You would be limited to 26 changes
4 You can do this by developing an appropiate trigger

[Quoted] Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun May 25 2003 - 13:12:40 CEST