Rem Create a new user "jdbcuser" that will be used in all JDBC code samples

CREATE USER jdbcuser IDENTIFIED BY jdbcuser123;

Rem Grant connect and resource access to the new "jdbcuser"

GRANT CONNECT, RESOURCE TO jdbcuser;

Rem Grant required access to the new "jdbcuser"

GRANT UNLIMITED TABLESPACE TO jdbcuser;

Rem Switch the current session to the new jdbcuser session

ALTER SESSION SET CURRENT_SCHEMA=jdbcuser;

Rem Used in the SQLXMLSample.java code sample

CREATE TABLE SQLXML_JDBC_SAMPLE (DOCUMENT XMLTYPE, ID NUMBER);

Rem Used in the PLSQLSample.java code sample

CREATE TABLE PLSQL_JDBC_SAMPLE

(NUM NUMBER(4) NOT NULL,

NAME VARCHAR2(20) NOT NULL,

INSERTEDBY VARCHAR2(20));

Rem Used in LOBBasic.java code sample

CREATE TABLE LOB_JDBC_SAMPLE

(LOB_ID INT NOT NULL,

BLOB_DATA BLOB,

CLOB_DATA CLOB,

NCLOB_DATA NCLOB);

Rem Used in DateTimeStampSample.java code sample

CREATE TABLE EMP_DATE_JDBC_SAMPLE

(EMP_ID INTEGER PRIMARY KEY,

DATE_OF_BIRTH DATE,

DATE_OF_JOINING TIMESTAMP WITH LOCAL TIME ZONE,

DATE_OF_RESIGNATION TIMESTAMP WITH TIME ZONE,

DATE_OF_LEAVING TIMESTAMP);

Rem Used in JSONBasicDemo.java code sample

CREATE TABLE JSON_EMP_JDBC_SAMPLE

(EMP_ID RAW(16) NOT NULL PRIMARY KEY,

DATE_LOADED TIMESTAMP WITH TIME ZONE,

EMPLOYEE_DOCUMENT CLOB CONSTRAINT

ENSURE_JSON CHECK (EMPLOYEE_DOCUMENT IS JSON));

Rem Used in JSONBasicDemo.java code sample

INSERT INTO JSON_EMP_JDBC_SAMPLE VALUES (SYS_GUID(), SYSTIMESTAMP, '{"employee_number": 1, "employee_name": "John Doe", "salary": 2000}');

INSERT INTO JSON_EMP_JDBC_SAMPLE VALUES (SYS_GUID(), SYSTIMESTAMP, '{"employee_number": 2, "employee_name": "Jane Doe", "salary": 2010}');

INSERT INTO JSON_EMP_JDBC_SAMPLE VALUES (SYS_GUID(), SYSTIMESTAMP, '{"employee_number": 3, "employee_name": "John Smith", "salary": 3000, "sons": [{"name": "Angie"}, {"name": "Linda"}]}');

INSERT INTO JSON_EMP_JDBC_SAMPLE VALUES (SYS_GUID(), SYSTIMESTAMP, '{"employee_number": 3, "employee_name": "Jane Williams", "salary": 1000, "sons": [{"name": "Rosie"}]}');