Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Name

CREATE SCHEMA

Synopsis

CREATE SCHEMA AUTHORIZATION schema
[CREATE TABLE statement]
[CREATE VIEW statement]   
[GRANT statement]

Creates multiple tables and/or views and issues grants in a single statement.

Tip

You must have the same privileges required for the CREATE TABLE, CREATE VIEW, and GRANT statements to issue this statement. Individual statements within the CREATE SCHEMA statement must not be terminated with the SQL termination character.

Keywords

schema

Name of the schema to be created, which must be the same as your username.

CREATE TABLE statement

This is a CREATE TABLE statement, as shown later in the CREATE TABLE entry.

CREATE VIEW statement

This is a CREATE VIEW statement, as shown later in the CREATE VIEW entry.

GRANT statement

This is a GRANT statement, as shown later in the GRANT entry.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page