| ROWID [message #6430] |
Wed, 16 April 2003 11:10  |
Dean
Messages: 34
Registered: August 2000
|
Member |
|
|
Hi
I am trying to create a unique ID for a cust_id field through the sql+ interface. I want the cust_id to be incremented by 1 every time a new custoemr is added through the sql+ interface as well as through Oracle forms. i have been reading a few books, and they mention the use of the datatype ROWID, just wondering if this is the way a new customer could be automatically issued with a unique id? If so how would I set a table up through sql+ assigning the data type to my cust_id?
Any ideas?
|
|
|
|
| Re: ROWID [message #6432 is a reply to message #6430] |
Wed, 16 April 2003 12:49  |
Todd Barry
Messages: 4819
Registered: August 2001
|
Senior Member |
|
|
No, you do not want to use ROWID to identify your customers. That is for internal Oracle use only.
Your original approach to use a sequence was the correct approach - why are you trying to find another unique identifier?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
