| Sequence @ WEBDB [message #77383] |
Tue, 23 July 2002 00:58  |
dieter
Messages: 17
Registered: February 2002
|
Junior Member |
|
|
Can anybody tell me how I can insert a sequence to increase the id, so it has to be automaticly inserted in the field.
It may only increase when you push on insert and it must be possible to query.
Thanks in advance,
Dieter
|
|
|
|
| Re: Sequence @ WEBDB [message #77385 is a reply to message #77383] |
Sun, 28 July 2002 17:36  |
Ages
Messages: 1
Registered: July 2002
|
Junior Member |
|
|
there are two options inserting a sequence automaticly into a number field :
1. use trigger
2. use query result from sequence ("select sequence_name.nextval from
dual") as default value for that field
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
