Retrieving (Autonumber)identity field after using trigger

Hi,

I am generating an autonumber using sequences and triggers as follows (belows example was taken from http://www.oracle-base.com) :

CREATE TABLE departments (
  ID NUMBER(10) NOT NULL,
  DESCRIPTION VARCHAR2(50) NOT NULL); ALTER TABLE departments ADD (
  CONSTRAINT dept_pk PRIMARY KEY (ID));

CREATE OR REPLACE TRIGGER dept_bir
BEFORE INSERT ON departments
REFERENCING OLD AS old NEW AS new
FOR EACH ROW
BEGIN
  IF :new.id IS NULL THEN
    SELECT dept_seq.NEXTVAL
    INTO :new.id
    FROM dual;
  END IF;
END;
/

To insert:
SQL> INSERT INTO departments (description)   2 VALUES ('Development');

My question is, how do I now retrieve the autonumber (Identity field) which I have just created ?

Any help would be much appreciated
mike Received on Wed Oct 23 2002 - 12:44:03 CEST