Sapna Malik
How many types of synonyms in Oracle?
By Sapna Malik in Databases & DBA on Jun 06 2011
  • Pankaj  Kumar Choudhary
    Jun, 2015 16

    Two types of synonyms in Oracle: Private Synonyms and Public Synonyms.

    • 0
  • Hamid Khan
    Apr, 2013 6

    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

    • 0
  • Rajendra  Singh
    Sep, 2012 25

    A synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects

    • 0
  • Sapna Malik
    Jun, 2011 6

    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.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS