Loading
How many types of synonyms in Oracle?
4 Answers
Two types of synonyms in Oracle: Private
Synonyms and Public Synonyms.
Pankaj Kumar ChoudharyPosted Jun 16, 2015, 11:20 AM
A synonym is an alternative name (Alias) for objects such as tables, views, sequences, but remember this alias name can't be the SQL Keyword
Hamid KhanPosted Apr 6, 2013, 2:52 AM
A synonym is an alternative name for objects such as tables, views, sequences,
stored procedures, and other database objects
Rajendra SinghPosted Sep 25, 2012, 7:52 AM
synonym is an alternative name for objects such as tables views sequences stored
procedures and other database objects.
A synonym (synonym-name) is an alias for an object (such as a table). The object
does not need to exist at the time of its creation. Synonyms can't be used in a
drop and truncate statements. If this is tried it results in a ORA-00942: table
or view does not exist.
Two types of synonyms in Oracle: Private Synonyms and Public Synonyms.
Sapna MalikPosted Jun 6, 2011, 1:10 AM