diff options
Diffstat (limited to 'bulk/oracle/auto/person.sql')
-rw-r--r-- | bulk/oracle/auto/person.sql | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/bulk/oracle/auto/person.sql b/bulk/oracle/auto/person.sql new file mode 100644 index 0000000..7676ef6 --- /dev/null +++ b/bulk/oracle/auto/person.sql @@ -0,0 +1,33 @@ +/* This file was generated by ODB, object-relational mapping (ORM) + * compiler for C++. + */ + +SET FEEDBACK OFF; +WHENEVER SQLERROR EXIT FAILURE; +WHENEVER OSERROR EXIT FAILURE; + +BEGIN + BEGIN + EXECUTE IMMEDIATE 'DROP TABLE "person" CASCADE CONSTRAINTS'; + EXCEPTION + WHEN OTHERS THEN + IF SQLCODE != -942 THEN RAISE; END IF; + END; + BEGIN + EXECUTE IMMEDIATE 'DROP SEQUENCE "person_seq"'; + EXCEPTION + WHEN OTHERS THEN + IF SQLCODE != -2289 THEN RAISE; END IF; + END; +END; +/ + +CREATE TABLE "person" ( + "id" NUMBER(20) NOT NULL PRIMARY KEY, + "num" NUMBER(10) NOT NULL UNIQUE, + "str" CLOB NOT NULL); + +CREATE SEQUENCE "person_seq" + START WITH 1 INCREMENT BY 1; + +EXIT; |