Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to Alter DUAL table to change value

How to Alter DUAL table to change value

From: BookerT <chipw_at_ascac.org>
Date: 13 Dec 2006 15:07:16 -0800
Message-ID: <1166051236.091770.211890@79g2000cws.googlegroups.com>


I am a novice user, but expected to do "Advanced things"

I have inherited some asp/vb code that queries and modifies an oracle database. Some of the code in the database builds a Select Statement from the DUAL table to generate the primary key sequence number for a few tables (maybe just one, I have not determined the full scope yet). One of my tables that I keep trying to add a record to through the asp code keeps giving me a unique constraint error.

This happened, I believe because we had to reimport the database from an earlier copy and thus numbers in the old tables reverted back to lower numbers.

So for example, since new records have been added, my primary key id number for one table is as high as 27348.

however when the code generates a number for the primary key id number, it has a number like 27257. I need to change the DUAL table entry, so that it starts at 27349 and that way when the code goes in and makes a connection to the database, it will pick up 27349 and then sequence from there.

How do I do that?

Currently in the code it goes:
SELECT Inquiries_seq.NextVal AS NextID
FROM DUAL Thanks for any opinions. Received on Wed Dec 13 2006 - 17:07:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US