text: CREATE TABLE IACUC_PROTOCOL_ALT_SEARCH ( 
      IACUC_PROTOCOL_ALT_SEARCH_ID NUMBER(12,0) NOT NULL, 
      PROTOCOL_ID NUMBER(12,0) NOT NULL,
      PROTOCOL_NUMBER VARCHAR2(20),
      SEQUENCE_NUMBER NUMBER(4,0) DEFAULT 1 NOT NULL,    
      SEARCH_REQUIRED VARCHAR2(1) NOT NULL,
      SEARCH_DATE DATE NOT NULL,
      YEARS_SEARCHED VARCHAR2(2000) NOT NULL,
      KEYWORDS VARCHAR2(2000) NOT NULL,
      COMMENTS CLOB,
      UPDATE_TIMESTAMP DATE NOT NULL, 
      UPDATE_USER VARCHAR2(60) NOT NULL, 
      VER_NBR NUMBER(8,0) DEFAULT 1 NOT NULL, 
      OBJ_ID VARCHAR2(36) NOT NULL
  ) 
  /
  
  ALTER TABLE IACUC_PROTOCOL_ALT_SEARCH 
  ADD CONSTRAINT PK_IACUC_PRTCL_ALT_SEARCH
  PRIMARY KEY (IACUC_PROTOCOL_ALT_SEARCH_ID) 
  /
  