Sapna Malik
How many types of synonyms in Oracle?
Posted by Sapna Malik in Database | Oracle on Jun 06, 2011
0
Do you know the answer for this question? Post it below.
Guest

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.

Posted by Sapna Malik on Jun 06, 2011
Sponsored by
6 Months Free & No Setup Fees ASP.NET Hosting!
Become a Sponsor
PREMIUM SPONSORS
  • ceTE software specializes in components for dynamic PDF generation and manipulation. The DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and new content to existing PDF documents from within your applications. Visit DynamicPDF here
    The leading .NET charting control now features PDF, Flash and Silverlight export, visualization of large datasets and more. Deliver true charting functionality to your BI, Scorecard, Presentation or Scientific apps. Download evaluation now.
Sponsored by
6 Months Free & No Setup Fees ASP.NET Hosting!
Become a Sponsor
PRIVACY POLICY | TERMS & CONDITIONS | SITEMAP | CONTACT US | REPORT ABUSE © 2011 C# Corner. All contents are copyright of their authors.