Draft implementation for INSERT

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;