Search results
Use the CREATE SYNONYM statement to create a synonym, which is an alternative name for a table, view, sequence, operator, procedure, stored function, package, materialized view, Java class schema object, user-defined object type, or another synonym.
Learn how to use the Oracle CREATE SYNONYM statement to create an alternative name for a database object such as a table, view, sequence, and procedure.
This Oracle tutorial explains how to create and drop synonyms in Oracle with syntax and examples. A synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects.
Use the CREATE SYNONYM statement to create a synonym, which is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object, or another synonym. Synonyms provide both data independence and location transparency.
Jun 9, 2023 · To create a synonym in Oracle (either private or public), we use the CREATE SYNONYM command. The syntax is: CREATE [OR REPLACE] [PUBLIC] SYNONYM [schema.] synonym_name FOR [schema.] object_name [@dblink_name];
Create synonym – show you how to create a new synonym for a table. Drop a synonym – describe how to drop a synonym from the database. In a distributed database system, synonyms help simplify SQL statements.
CREATING SYNONYMS. To create a synonym for SCOTT emp table give the following command. create synonym employee for scott.emp; A synonym can be referenced in a DML statement the same way that the underlying object of the synonym can be referenced.
May 14, 2020 · Synonym is an object that points to a specific object in the Oracle database. There are lots of database objects which names are very long and complex. You can create Synonym for these objects and use the Synonym instead of its original name.
Use the CREATE SYNONYM statement to create a synonym, which is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object, user-defined object type, or another synonym.
You must have the CREATE SYNONYM privilege to create a private synonym in your own schema, and CREATE ANY SYNONYM to create a synonym in another schema. You must have the CREATE PUBLIC SYNONYM privilege to create a public synonym.