Oracle DBA SQL Quick Reference

Create statements create new objects.

Create Cluster

Create a new cluster in the existing database.

Create Context

Create a context and associate a namespace with external packages.

Create Controlfile

Create or recreate a control file.

Logfile

Character set

Create Database

Creates a database and erases any data in specified files

Default temp tablespace

Temp tablespace extent

Undo tablespace

Set time zone

Create Database Link

Create a link to a remote database object.

Authenticated

Create Dimension

Create a dimension, a parent child relationship between column set pairs.

Level

Hierarchy

Join

Attribute

Create Directory

Create a directory.

Create Function

Create a standalone stored function or call.

Invoker rights

Parallel enable

Streaming

Call spec

Java declaration

C declaration

Create Index

Create an index.

Cluster index

Table index

Bitmap join index

Index expression

Index attributes

Physical attributes

Logging

Key compression

Domain index

Global partitioned index

Global partitioning

Local partitioned index

On range partitioned table

On list partitioned table

Segment attributes

On hash partitioned table

On composite partitioned table

Index subpartition

Parallel

Create Indextype

Create an indextype object.

Create Java

Create a Java object containing a Java resource, class or source.

Invoker rights

Create Library

Create a callable object associated with an OS shared library.

Create Materialized View

Create a materialized view of the results of a query.

Materialized view properties

Prebuilt table

Scoped table ref constraint

Index organized table

Key compression

Index organized overflow

Create materialized view refresh

Segment attributes

Physical attributes

Logging

Data segment compression

Physical attributes

Object type column properties

Substitutable column

Nested table column properties

Varray column properties

LOB storage

LOB parameters

LOB partition storage

Parallel

Build

Create Materialized View Log

Create a materialized view log.

New values

Create Operator

Create an operator and define its bindings.

Binding

Implementation

Context

Using function

Create Outline

Create an outline for the optimizer.

Create Package

Create a package of stored procedures, functions and other objects.

Invoker rights

Create Package Body

Create the body of a stored package.

Create pfile

Export a binary parameter file into a text initialization file.

Create Procedure

Create a standalone stored procedure.

Invoker rights

Call spec

Java declaration

C declaration

Create Profile

Create a profile to set limits on database resources.

Resource parameters

Resource parameters

Create Role

Create a role “ a grouping of a privileges that can be granted to users or other roles.

Create Rollback Segment

Create a rollback segment.

Create Schema

Create a multiple tables, views and grants as a single transaction.

Create Sequence

Create a sequence.

Create spfile

Create a binary server parameter file from a client initialization file.

Create Synonym

Create a synonym to a database object.

Create Table

Create a table.

Relational table

Object table

XMLType table

Relational properties

Object table substitution

Object properties

OID

OID index

Physical properties

Segment attributes

Physical attributes

Data segment compression

Table properties

Cloumn properties

Object type column properties

Substitutable column

Nested table column properties

Varray column properties

LOB storage

LOB parameters

Logging

LOB partition storage

XMLType column properties

XMLType storage

XMLSchema spec

Row movement

Index organized table

Mapping table

Key compression

Index organized overflow

Supplemental logging properties

External table

External data properties

Table partitioning

Range partitioning

Hash partitioning

List partitioning

Composite partitioning

Subpartition by hash

Individual hash partitions

Hash partitions by quantity

Subpartition by list

Subpartition template

List values

Range values

Table partition description

Partition level subpartition

Subpartition spec

Partitioning storage

Parallel

Enable disable

Using index

Global partitioned index

Global partitioning

Create Tablespace

Create a new tablespace.

Data segment compression

Extent management

Segment management

Create Temporary Tablespace

Create a new temporary tablespace.

Temp tablespace extent

Create Trigger

Create and enable a database trigger.

DML event

Referencing

Create Type

Create the specifications for an object type. Use the CREATE TYPE BODY statement to actually assign the code for the type.

Create incomplete type

Create object type

Invoker rights

sqlj object type

sqlj object type attribute

Element specification

Inheritance

Subprogram

Procedure specification

Function specification

Constructor specification

Map order function spec

Return

sqlj object type sig

Pragma

Call specification

Java declaration

C declaration

Create varray type

Create nexted table type

Create Type Body

Create the code for the methods defined by the CREATE TYPE statement.

Procedure declaration

Function declaration

Constructor declaration

Call specification

Java declaration

C declaration

Create User

Create a new user and define storage, password, quotas and other details for the user.

Create View

Define a logical table or view of one or more tables or views.

Object view

XMLType view

XMLSchema spec

Subquery restriction