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/DROP SYNONYM

Synopsis

CREATE Syntax:

CREATE [PUBLIC] SYNONYM synonym_name
FOR [schema.]object_name[@dblink]

DROP Syntax:

DROP [PUBLIC] SYNONYM [schema.]synonym_name

Creates or removes a public or private synonym for a database object.

Keywords

PUBLIC

Specifies that this synonym will be available to all users. If omitted, the synonym will be available only to the schema owner.

synonym_name

Name of the new synonym.

object_name

Name of the object to which the synonym will refer. It may include a reference to a remote database by appending the @dblink syntax.

Tip

Oracle resolves object names in the current schema first, so a PUBLIC synonym will be used only if the object name is not prefaced with a schema name, is not followed by a dblink, and does not exist in the current schema.

Common keywords and clauses: dblink, schema.

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