From 0d0e4b23176f0b55d7948ffef9b9ffdad6a95973 Mon Sep 17 00:00:00 2001
From: Boris Kolpackov <boris@codesynthesis.com>
Date: Thu, 14 Aug 2014 09:37:06 +0200
Subject: Draft implementation for INSERT

---
 bulk/oracle/auto/person.sql | 33 +++++++++++++++++++++++++++++++++
 1 file changed, 33 insertions(+)
 create mode 100644 bulk/oracle/auto/person.sql

(limited to 'bulk/oracle/auto/person.sql')

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;
-- 
cgit v1.1