For people who are used to SQL server, the best thing to do would be to setup a trigger and that trigger in Oracle could grab the next sequence value and insert it when new data is being inserted into the table.
On 10/5/06, Doug Bezona <[EMAIL PROTECTED]> wrote: > > > You can access the sequence in a couple of ways. One is using > foo_sq.NextVal directly in the insert statement, as the original poster > was doing. > > The other is to select it from DUAL, which is a sort of utility table in > Oracle, like so: > > Select foo_sq.NextVal as id > From DUAL > > -- Aaron Rouse http://www.happyhacker.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255715 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
