DDL

/* TAB1: reference list */

CREATE TABLE tab1
  (f1 NUMBER,
   f2 DATE,
   f3 VARCHAR2(32),

   constraint pk_tab1
   primary key(f1,f2)
  );


/* TAB2: reference list */

CREATE TABLE tab2
  (f1 NUMBER,
   f4 VARCHAR2(40)

   constraint pk_tab2
   primary key(f1)
  );