Daily Archives: March 8, 2010

Oracle Synonym example

Published March 8, 2010 | By admin

Oracle synonyms are short names (and easy to remember) for other Oracle object names. The other oracle objects can be tables, views, procedures, functions, packages and other Oracle objects and may be in the same schema or in another schema or in another database.

Synonyms can be PRIVATE or PUBLIC. If you create a private synonym then only you can use that synonym. The default is PRIVATE.

PUBLIC synonyms can be used by all database users. Continue reading →

Posted in PL/SQL Tutorial | Tagged , , | Leave a comment


Loading





Copyright © 2009. All Rights Reserved.