ITRemote

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;