CREATE SEQUENCE   "USERMASTER_SEQ"  
MINVALUE 1 
MAXVALUE 9999999999999999999999999999
INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOPARTITION
/

CREATE TABLE  "USERMASTER" 
   ( 	"USER_ID" NUMBER NOT NULL ENABLE, 
	"USERNAME" VARCHAR2(20) NOT NULL ENABLE, 
	"FULL_NAME" VARCHAR2(100) NOT NULL ENABLE,
	"EMAIL_ADDRESS" VARCHAR2(100) NOT NULL ENABLE,
	"PWD_EXPIRE" NUMBER(1,0) NOT NULL ENABLE, 
	"PWD" VARCHAR2(60) NOT NULL ENABLE, 
	 CONSTRAINT "USERMASTER_PK" PRIMARY KEY ("USER_ID")
  	USING INDEX  ENABLE, 
	 CONSTRAINT "USERMASTER_UK1" UNIQUE ("USERNAME")
  	USING INDEX  ENABLE, 
	 CONSTRAINT "USERMASTER_UK2" UNIQUE ("EMAIL_ADDRESS")
  	USING INDEX  ENABLE
   )
/

CREATE OR REPLACE EDITIONABLE TRIGGER  "BI_USERMASTER" 
  before insert on "USERMASTER"               
  for each row  
begin   
  if :NEW."USER_ID" is null then 
    select "USERMASTER_SEQ".nextval into :NEW."USER_ID" from sys.dual; 
  end if; 
end;
/

ALTER TRIGGER  "BI_USERMASTER" ENABLE
/