So you are saying that the sequence jumps more than 1 increment at a time?
If that is the case, perhaps the records are getting inserted and the sequence is being inserted as normal... but somewhere in the proccess, the inserts are not being commited...perh aps a rollback occuring, and only some of the records are being commited.
i2eye
Last Activity: Feb 23 '07, 10:52 PM
Joined: Nov 17 '06
Location:
-
Have you tried using Analytic Functions? See if this works... not sure with the syntax of your table... you might have to play with it.
Select DISTINCT $A$.USER_ID, $A$.EMAIL, $A$.FIRST_NAME, $A$. LAST_NAME,
$A$.COBRAND_ID, $A$.SUBSCRIBED, $B$.USER_COMM_A LERT_ID,
$B$.PREF_ACTIVE _FLAG, MAX($B$.TIMESTA MP_) OVER (PARTITION BY $B$.TIMESTAMP_)
From $A$ INNER JOIN $B$ ON $A$.USER_ID=$B$ .USER_ID
...Leave a comment:
-
It depends on what your table structure is like... say you have a table called table_name, and the identifier is a sequence number called column_id, you can do a subquery... that gets the maximum column_id... then the outer query is to return everything else, see below.
SELECT * FROM table_name WHERE column_id = (
SELECT max(column_id)
FROM table_name );
You may consider looking up Analytical...Leave a comment:
-
It is SQL Loader, it is an oracle utility used to load data into your database from a text file.
In unix I use a control file to tell what location in the text file is to go into what column in the table.
Sqlldr is useful if you need to load thousands of data all at once.Leave a comment:
-
Here is another way to do a loop:
DECLARE
max_count NUMBER := 20;
BEGIN
FOR i IN 1..max_count LOOP
dbms_output.put _line(i);
END LOOP;
END;Leave a comment:
No activity results to display
Leave a comment: