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 generation of unique row ID

415959Mar 1 2004 — edited Mar 2 2004

Hello all

I'm quite new to Oracle Database. Still learning a little but there's something I need some help with.

Let's say I create a table called 'ABC_LOGN' with three columns, 'ABC_ID', 'ABC_USER' and 'ABC_PASS'. When values are inserted into ABC_USER and ABC_PASS, I need ABC_ID to automatically generate an alphanumeric value (preferably 4 or more characters). ABC_ID needs to act as a unique "identifier" for each user throughout the system.

Any help or direction would be most appreciated.

Thank you for your time

Jack

Oracle9i Database
Windows XP

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 30 2004

Added on Mar 1 2004

#general-database-discussions

5 comments

1,144 views