SELECT sequence-name.CURRVAL;

SELECT sequence-name.NEXTVAL;

CREATE SEQUENCE incidentSequence
   MINVALUE 1000
   MAXVALUE 100000;

CREATE TABLE reportedBillingMistake( 
   incidentID INT PRIMARY KEY DEFAULT (incidentSequence.nextval),
   billNumber INT,
   valueOnBill NUMERIC(10,2),
   expectedValue NUMERIC(10,2),
   comments LONG VARCHAR );

CREATE TABLE reportedMissingShipment( 
   incidentID INT PRIMARY KEY DEFAULT(incidentSequence.nextval),
   orderNumber INT,
   comments LONG VARCHAR );

INSERT INTO reportedBillingMistake VALUES( DEFAULT, 12345, 100.00, 75.00, 'Bad bill' );

INSERT INTO reportedBillingMistake
   SELECT incidentSequence.nextval, 12345, 100.00, 75.00, 'Bad bill';

SELECT incidentSequence.currval;