INSERT INTO DC_SEQUENCES (
  SEQUENCE_NAME, 
  LAST_NUMBER)
SELECT 'array_gene_map_file_id', NVL(MAX(ARRAY_GENE_MAP_FILE_ID), 0)
  FROM ARRAY_GENE_MAP_FILE;

COMMIT;

/*
Select the new key and maintain latest key value in the DC_SEQUENCES table.

To do this in the java code:
1. Verify that auto-commit is disabled
2. SELECT the key value from the table.
3. UPDATE the key value (by incrementing it) in the sequence table.
4. COMMIT the connection and set back to auto-commit
5. Store the keys.

PLEASE REFER TO objectKeymanagement FOR DETAILS.

SQL statements:

2. 
SELECT LAST_NUMBER FROM DC_SEQUENCES
WHERE  upper(SEQUENCE_NAME) = upper(<the name of the sequence>); 

3.
UPDATE DC_SEQUENCES SET LAST_NUMBER = 
       LAST_NUMBER + <the block of number that you want to get>
WHERE  upper(SEQUENCE_NAME) = upper(<the name of the sequence>);

4.
COMMIT;

*/


