[Summary view] [Print] [Text view]

   1  BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE test_one_table_object_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
   2  /
   3  CREATE SEQUENCE test_one_table_object_seq;
   4  /
   5  BEGIN EXECUTE IMMEDIATE 'DROP TABLE test_one_table_object'; EXCEPTION WHEN OTHERS THEN NULL; END;
   6  /
   7  CREATE TABLE test_one_table_object (
   8    id number NOT NULL,
   9    annotation clob,
  10    content clob,
  11    news_date varchar(255) default NULL,
  12    ordr number default NULL,
  13    PRIMARY KEY  (id)
  14  );
  15  /
  16  CREATE OR REPLACE TRIGGER test_one_table_object_trigger
  17  BEFORE INSERT ON test_one_table_object REFERENCING NEW AS NEW FOR EACH ROW
  18  BEGIN IF :NEW.ID IS NULL THEN SELECT test_one_table_object_seq.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
  19  /
  20  BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE test_auto_times_object_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
  21  /
  22  CREATE SEQUENCE test_auto_times_object_seq;
  23  /
  24  BEGIN EXECUTE IMMEDIATE 'DROP TABLE test_auto_times_object'; EXCEPTION WHEN OTHERS THEN NULL; END;
  25  /
  26  CREATE TABLE test_auto_times_object (
  27    id number NOT NULL,
  28    content clob,
  29    ctime number default NULL,
  30    mtime number default NULL,
  31    PRIMARY KEY  (id)
  32  );
  33  /
  34  CREATE OR REPLACE TRIGGER test_auto_times_object_trigger
  35  BEFORE INSERT ON test_auto_times_object REFERENCING NEW AS NEW FOR EACH ROW
  36  BEGIN IF :NEW.ID IS NULL THEN SELECT test_auto_times_object.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
  37  /
  38  BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE test_one_table_typed_objec_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
  39  /
  40  CREATE SEQUENCE test_one_table_typed_objec_seq;
  41  /
  42  BEGIN EXECUTE IMMEDIATE 'DROP TABLE test_one_table_typed_object'; EXCEPTION WHEN OTHERS THEN NULL; END;
  43  /
  44  CREATE TABLE test_one_table_typed_object (
  45    id number NOT NULL,
  46    title clob,
  47    kind varchar(255) NOT NULL,
  48    PRIMARY KEY  (id)
  49  );
  50  /
  51  CREATE OR REPLACE TRIGGER test_one_table_typed_trigger
  52  BEFORE INSERT ON test_one_table_typed_object REFERENCING NEW AS NEW FOR EACH ROW
  53  BEGIN IF :NEW.ID IS NULL THEN SELECT test_one_table_typed_objec_seq.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
  54  /
  55  BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE course_for_typed_test_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
  56  /
  57  CREATE SEQUENCE course_for_typed_test_seq;
  58  /
  59  BEGIN EXECUTE IMMEDIATE 'DROP TABLE course_for_typed_test'; EXCEPTION WHEN OTHERS THEN NULL; END;
  60  /
  61  CREATE TABLE course_for_typed_test (
  62    id number NOT NULL,
  63    title varchar(255) default NULL,
  64    PRIMARY KEY  (id)
  65  );
  66  /
  67  CREATE OR REPLACE TRIGGER course_for_typed_test_trigger
  68  BEFORE INSERT ON course_for_typed_test REFERENCING NEW AS NEW FOR EACH ROW
  69  BEGIN IF :NEW.ID IS NULL THEN SELECT course_for_typed_test_seq.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
  70  /
  71  BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE lecture_for_typed_test_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
  72  /
  73  CREATE SEQUENCE lecture_for_typed_test_seq;
  74  /
  75  BEGIN EXECUTE IMMEDIATE 'DROP TABLE lecture_for_typed_test'; EXCEPTION WHEN OTHERS THEN NULL; END;
  76  /
  77  CREATE TABLE lecture_for_typed_test (
  78    id number NOT NULL,
  79    title varchar(255) default NULL,
  80    course_id number default NULL,
  81    kind varchar(255) NOT NULL,
  82    PRIMARY KEY  (id)
  83  );
  84  /
  85  CREATE OR REPLACE TRIGGER lecture_for_typed_test_trigger
  86  BEFORE INSERT ON lecture_for_typed_test REFERENCING NEW AS NEW FOR EACH ROW
  87  BEGIN IF :NEW.ID IS NULL THEN SELECT lecture_for_typed_test_seq.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
  88  /
  89  BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE social_security_for_test_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
  90  /
  91  CREATE SEQUENCE social_security_for_test_seq;
  92  /
  93  BEGIN EXECUTE IMMEDIATE 'DROP TABLE social_security_for_test'; EXCEPTION WHEN OTHERS THEN NULL; END;
  94  /
  95  CREATE TABLE social_security_for_test (
  96    id number NOT NULL,
  97    code varchar(255) default NULL,
  98    PRIMARY KEY  (id)
  99  );
 100  /
 101  CREATE OR REPLACE TRIGGER social_security_for_trigger
 102  BEFORE INSERT ON social_security_for_test REFERENCING NEW AS NEW FOR EACH ROW
 103  BEGIN IF :NEW.ID IS NULL THEN SELECT social_security_for_test_seq.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
 104  /
 105  BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE person_for_test_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
 106  /
 107  CREATE SEQUENCE person_for_test_seq;
 108  /
 109  BEGIN EXECUTE IMMEDIATE 'DROP TABLE person_for_test'; EXCEPTION WHEN OTHERS THEN NULL; END;
 110  /
 111  CREATE TABLE person_for_test (
 112    id number NOT NULL,
 113    name varchar(255) default NULL,
 114    ss_id number default NULL,
 115    PRIMARY KEY  (id)
 116  );
 117  /
 118  CREATE OR REPLACE TRIGGER person_for_test_trigger
 119  BEFORE INSERT ON person_for_test REFERENCING NEW AS NEW FOR EACH ROW
 120  BEGIN IF :NEW.ID IS NULL THEN SELECT person_for_test_seq.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
 121  /
 122  BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE course_for_test_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
 123  /
 124  CREATE SEQUENCE course_for_test_seq;
 125  /
 126  BEGIN EXECUTE IMMEDIATE 'DROP TABLE course_for_test'; EXCEPTION WHEN OTHERS THEN NULL; END;
 127  /
 128  CREATE TABLE course_for_test (
 129    id number NOT NULL,
 130    title varchar(255) default NULL,
 131    PRIMARY KEY  (id)
 132  );
 133  /
 134  CREATE OR REPLACE TRIGGER course_for_test_trigger
 135  BEFORE INSERT ON course_for_test REFERENCING NEW AS NEW FOR EACH ROW
 136  BEGIN IF :NEW.ID IS NULL THEN SELECT course_for_test_seq.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
 137  /
 138  BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE lecture_for_test_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
 139  /
 140  CREATE SEQUENCE lecture_for_test_seq;
 141  /
 142  BEGIN EXECUTE IMMEDIATE 'DROP TABLE lecture_for_test'; EXCEPTION WHEN OTHERS THEN NULL; END;
 143  /
 144  CREATE TABLE lecture_for_test (
 145    id number NOT NULL,
 146    title varchar(255) default NULL,
 147    course_id number default NULL,
 148    alt_course_id number default NULL,
 149    PRIMARY KEY  (id)
 150  );
 151  /
 152  CREATE OR REPLACE TRIGGER lecture_for_test_trigger
 153  BEFORE INSERT ON lecture_for_test REFERENCING NEW AS NEW FOR EACH ROW
 154  BEGIN IF :NEW.ID IS NULL THEN SELECT lecture_for_test_seq.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
 155  /
 156  BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE lesson_for_test_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
 157  /
 158  CREATE SEQUENCE lesson_for_test_seq;
 159  /
 160  BEGIN EXECUTE IMMEDIATE 'DROP TABLE lesson_for_test'; EXCEPTION WHEN OTHERS THEN NULL; END;
 161  /
 162  CREATE TABLE lesson_for_test (
 163    id number NOT NULL,
 164    date_start number default NULL,
 165    date_end number default NULL,
 166    PRIMARY KEY  (id)
 167  );
 168  /
 169  CREATE OR REPLACE TRIGGER lesson_for_test_trigger
 170  BEFORE INSERT ON lesson_for_test REFERENCING NEW AS NEW FOR EACH ROW
 171  BEGIN IF :NEW.ID IS NULL THEN SELECT lesson_for_test_seq.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
 172  /
 173  BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE group_for_test_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
 174  /
 175  CREATE SEQUENCE group_for_test_seq;
 176  /
 177  BEGIN EXECUTE IMMEDIATE 'DROP TABLE group_for_test'; EXCEPTION WHEN OTHERS THEN NULL; END;
 178  /
 179  CREATE TABLE group_for_test (
 180    id number NOT NULL,
 181    title varchar(255) default NULL,
 182    PRIMARY KEY  (id)
 183  );
 184  /
 185  CREATE OR REPLACE TRIGGER group_for_test_trigger
 186  BEFORE INSERT ON group_for_test REFERENCING NEW AS NEW FOR EACH ROW
 187  BEGIN IF :NEW.ID IS NULL THEN SELECT group_for_test_seq.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
 188  /
 189  BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE user_for_test_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
 190  /
 191  CREATE SEQUENCE user_for_test_seq;
 192  /
 193  BEGIN EXECUTE IMMEDIATE 'DROP TABLE user_for_test'; EXCEPTION WHEN OTHERS THEN NULL; END;
 194  /
 195  CREATE TABLE user_for_test (
 196    id number NOT NULL,
 197    first_name varchar(255) default NULL,
 198    PRIMARY KEY  (id)
 199  );
 200  /
 201  CREATE OR REPLACE TRIGGER user_for_test_trigger
 202  BEFORE INSERT ON user_for_test REFERENCING NEW AS NEW FOR EACH ROW
 203  BEGIN IF :NEW.ID IS NULL THEN SELECT user_for_test_seq.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
 204  /
 205  BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE user2group_for_test_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
 206  /
 207  CREATE SEQUENCE user2group_for_test_seq;
 208  /
 209  BEGIN EXECUTE IMMEDIATE 'DROP TABLE user2group_for_test'; EXCEPTION WHEN OTHERS THEN NULL; END;
 210  /
 211  CREATE TABLE user2group_for_test (
 212    id number NOT NULL,
 213    user_id number default NULL,
 214    group_id number default NULL,
 215    PRIMARY KEY  (id)
 216  );
 217  /
 218  CREATE OR REPLACE TRIGGER user2group_for_test_trigger
 219  BEFORE INSERT ON user2group_for_test REFERENCING NEW AS NEW FOR EACH ROW
 220  BEGIN IF :NEW.ID IS NULL THEN SELECT user2group_for_test_seq.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
 221  /
 222  BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE extended_user2group_for_test_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
 223  /
 224  CREATE SEQUENCE extended_user2group_for_test_seq;
 225  /
 226  BEGIN EXECUTE IMMEDIATE 'DROP TABLE extended_user2group_for_test'; EXCEPTION WHEN OTHERS THEN NULL; END;
 227  /
 228  CREATE TABLE extended_user2group_for_test (
 229    id number NOT NULL,
 230    user_id number default NULL,
 231    group_id number default NULL,
 232    other_id number default NULL,
 233    PRIMARY KEY  (id)
 234  );
 235  /
 236  CREATE OR REPLACE TRIGGER extended_user2group_for_test_trigger
 237  BEFORE INSERT ON extended_user2group_for_test REFERENCING NEW AS NEW FOR EACH ROW
 238  BEGIN IF :NEW.ID IS NULL THEN SELECT extended_user2group_for_test_seq.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;