[code language=”sql”]

CREATE TABLE "GG_INST"
( "GG_IN_ID" NUMBER,
"GG_IN_DSC" VARCHAR2(4000),
"GG_IN_NM" VARCHAR2(100),
"GG_IN_VER" VARCHAR2(50),
"GG_LST_PTCH" VARCHAR2(4000),
"GG_SRV_HM" NUMBER,
"GG_SRV_FO" NUMBER,
"GG_INST_CR_DT" TIMESTAMP (6),
"GG_IN_CLS_NM" VARCHAR2(4000),
"GG_IN_HST_NM" NUMBER,
"GG_SRC_DB" NUMBER,
"GG_XAG" VARCHAR2(1),
"GG_CRS_ENTRY" VARCHAR2(4000),
CONSTRAINT "GG_INST_PK" PRIMARY KEY ("GG_IN_ID")
USING INDEX ENABLE
) ;
CREATE OR REPLACE TRIGGER "BI_GG_INST"
before insert on "GG_INST"
for each row
begin
if :NEW."GG_IN_ID" is null then
select "GG_INST_SEQ".nextval into :NEW."GG_IN_ID" from dual;
end if;
end;

/
ALTER TRIGGER "BI_GG_INST" ENABLE;

[/code]