aboutsummaryrefslogtreecommitdiff
path: root/bulk/oracle/auto/person.sql
diff options
context:
space:
mode:
Diffstat (limited to 'bulk/oracle/auto/person.sql')
-rw-r--r--bulk/oracle/auto/person.sql33
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;