Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » Sequence @ WEBDB
Sequence @ WEBDB [message #77383] Tue, 23 July 2002 00:58 Go to next message
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 Go to previous message
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
Previous Topic: Re: Oracle webdb download
Next Topic: Portal 3.0 Configuration Problem
Goto Forum:
  


Current Time: Thu Mar 28 19:00:01 CDT 2024