Connecting to Oracle Database 12c
undcemcs02> sqlplus C##user.id/password@//65.52.222.73:1521/cdb1
SQL*Plus: Release 12.1.0.2.0 Production on Wed Sep 17 11:59:28 2021
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Tue Sep 07 2021 19:32:10 -05:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 -
64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application
Testing options
SQL>
Creating the inventory Table
SQL> CREATE TYPE author_t AS OBJECT ( name VARCHAR(64) );
2 /
Type created.
SQL> CREATE TYPE authors_t AS VARRAY(10) OF author_t;
2 /
Type created.
SQL> CREATE TABLE inventory (
2 title VARCHAR(64) NOT NULL,
3 ISBN CHAR(12) PRIMARY KEY,
4 authors authors_t NOT NULL,
5 price NUMBER(5,2) NOT NULL CHECK( price >= 0.0 ),
6 quantity INTEGER NOT NULL CHECK( quantity >= 0 ) );
Table created.
SQL> commit;
Commit complete.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 -
64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing
options
undcemcs02>
Using a File of Statements to Create a Database
undcemcs02> cat create.sql
DROP TABLE inventory;
DROP TYPE authors_t;
DROP TYPE author_t;
CREATE TYPE author_t AS OBJECT ( name VARCHAR(64) );
CREATE TYPE authors_t AS VARRAY(10) OF author_t;
CREATE TABLE inventory (
title VARCHAR(64) NOT NULL,
ISBN CHAR(12) PRIMARY KEY,
authors authors_t NOT NULL,
price NUMBER(5,2) NOT NULL CHECK( price >= 0.0 ),
quantity INTEGER NOT NULL CHECK( quantity >= 0 ) );
undcemcs02> sqlplus C##user.id/password@//65.52.222.73:1521/cdb1 @create.sql