Database Reference
In-Depth Information
Here, the object
ValidDate
(which could be any valid Oracle database object,
including a function) resides in a schema called Jones, and synonym is created in the
current schema.
The syntax for deleting a synonym is:
11.12 Summary and Concluding Remarks
It's time to summarize what was covered in this chapter:
•
The Oracle SQL*Plus environment provides a line editor that
allows you to enter, edit and execute SQL statements. However,
you may use any text editor of your choice and import the SQL
statement into the SQL*Plus environment. Other alter GUI-based
environments are iSQL *Plus, Oracle Enterprise Manager (OEM),
and Oracle SQL Developer (OSQLD).
•
The
Create-Database
statement allows you to create an Oracle
database. Alternately, you may use the Oracle DBCA.
•
The
Alter-Database
statement allows you to change features of a
database, and the
Drop-Database
statement allows you to delete
the current database. Alternately, you may use the Oracle DBCA.
•
The
Create-Tablespace
statement allows you to create a
tablespace. The
Alter-Tablespace
statement allows you to change
features of a tablespace, and the
Drop-Tablespace
statement
allows you to delete a tablespace.
•
The
Create-Table
statement allows you to create a table. The
Alter-Table
statement allows you to change features of a table,
and the
Drop-Table
statement allows you to delete a table.
•
The
Create-Index
statement allows you to create an index. The
Alter-Index
statement allows you to change features of an index,
and the
Drop-Index
statement allows you to delete an index.
•
The
Create-Sequence
statement allows you to create a sequence.
The
Alter-Sequence
statement allows you to change features of a
sequence, and the
Drop-Sequence
statement allows you to delete
a sequence.
•
The
Create-Synonym
statement allows you to create a synonym.
The
Drop-Synonym
statement allows you to delete a synonym.
Each of the database objects discussed in this chapter can be created and fully
managed using the OEM, OSQLD, or Oracle iSQL *Plus. However, in the interest of
learning SQL, it is recommended that you stick with SQL *Plus. The upcoming chapter
discusses the common DML and DCL statements of SQL.