Showing posts with label Synonyms. Show all posts
Showing posts with label Synonyms. Show all posts

Friday, January 12, 2024

SQL Synonyms | Synonyms | Private Synonym | Public Synonym | SQL | Oracle SQL

 

Synonyms

Creating and Dropping Synonyms

•       Creating a synonym eliminates the need to qualify the object name with the schema and provides you with an alternative name for a table, view, sequence, procedure, or other objects.

Syntax:

                CREATE [PUBLIC] SYNONYM synonymname

                FOR object;