SQL & PL/SQL

oracle version
10.2.0

sequence

CREATE SEQUENCE ADM_SQ_TABLE_GROUP
  START WITH 21
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 20
  NOORDER;

Master table

CREATE TABLE ADM_TL_TABLE_GROUPMST
(
TBGM_KEYID   VARCHAR2(6)    NOT NULL,
TBGM_NAME    VARCHAR2(50)   NOT NULL,
TBGM_CODE    VARCHAR2(15)   NOT NULL,
CONSTRAINT PK_ADM_TL_TABLE_GROUPMST PRIMARY KEY (TBGM_KEYID),
CONSTRAINT UK_TBGM_CODE UNIQUE(TBGM_CODE)
);

Insert values

INSERT INTO ADM_TL_TABLE_GROUPMST VALUES (adm_sq_table_group.NEXTVAL, 'PCS TABLE GROUP', 'PCS');

Details table

CREATE TABLE ADM_TL_TABLE_GROUPDTL
(
TBGD_KEYID  VARCHAR2(8) NOT NULL,
TBGD_MASTERID VARCHAR2(6)    NOT NULL,
TBGD_TABLENAME  VARCHAR2(30)    NOT NULL,
TBGD_ORDER      NUMBER(2)   NOT NULL,
CONSTRAINT PK_ADM_TL_TABLE_GROUPDTL PRIMARY KEY (TBGD_KEYID),
CONSTRAINT FK_TBGD_MASTERID FOREIGN KEY (TBGD_MASTERID) REFERENCES  ADM_TL_TABLE_GROUPMST(TBGM_KEYID)
);

insert script

INSERT INTO ADM_TL_TABLE_GROUPDTL VALUES (adm_sq_table_group.NEXTVAL, adm_sq_table_group.CURVAL, 'PCS_TL_MST', 1);

How to get previously generated sequence values