-
Creating a Unique Identifier of a Sequence and a Character
Hi all,
I'm attempting to create a unique identifier field in a table that consists of a character (representing the Oracle instance) and the value of a sequence. In essence, when a value is inserted into the table by an application, the unique field value will be:
Character + nextval from a sequence.
Thus, I'm trying to create a sequence that contains the character and the numbers generated by the sequence.
Does anyone know how this can be done?
Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|