-
Is there anyway of defining a column in an oracle database as a autonumber similar to the way you can in Access. I basically wish to declare that the primary key of the table that i'm creating will be unique and it will auto-increment each time a record is added.
Can anyone hepl me with the sql syntax for this?
-
Hi
You gotta use a sequence and tehn use a befire insert trigger.
regards
hrishy
-
thanks for that but I am a real beginner at this stuff could you expand a little more on what you mean.
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
|