changeset 122:2fea753a51ff

Added quote to examples.
author Oleksandr Gavenko <gavenkoa@gmail.com>
date Mon, 27 Mar 2017 20:42:26 +0300
parents 87f69a87c491
children 400c46fe348c
files 144b3e26-1301-4cc6-8e87-9395163ea633/index.rst
diffstat 1 files changed, 3 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/144b3e26-1301-4cc6-8e87-9395163ea633/index.rst	Mon Mar 27 15:44:35 2017 +0300
+++ b/144b3e26-1301-4cc6-8e87-9395163ea633/index.rst	Mon Mar 27 20:42:26 2017 +0300
@@ -11,14 +11,14 @@
 
 MySQL database has syntax to prevent error on ``create table`` if table is already exist::
 
-  create table if not exist TBL (...);
+  create table if not exist "TBL" (...);
 
 Unfortunately Oracle database hasn't such syntax. But it can be mimicked with PL/SQL code block and
 exception handling. Because PL/SQL code doesn't allow DDL code we use dynamic queries::
 
   declare
   begin
-    execute immediate 'create table TBL ("ID" number not null)';
+    execute immediate 'create table "TBL" ("ID" number not null)';
     exception when others then null;
   end;
   /
@@ -33,7 +33,7 @@
   declare
   begin
     execute immediate '
-      create table TBL ("ID" number not null)';
+      create table "TBL" ("ID" number not null)';
     exception when others then
       if SQLCODE = -955 then null; else raise; end if;
   end;