How to Create Synonyms in Oracle using TOAD for Oracle
A synonym is a database object that provides a better name to refer to objects. You can use synonyms to shorten lengthy names or to ease the reference to an object owned by another user. You can create synonyms for a table, view, sequence, procedure and other objects.
In this post I will show you how to create Synonyms in Oracle Database using TOAD for Oracle.
Connect to Oracle Database using TOAD. Click on Database menu and open Schema Browser
On the Schema Browser open Synonyms Tab and click on New button to create synonym
Create Synonym window will open, select the object type (Here I am creating synonym by using Table object). Find your required Object and move it from Available Objects. Give the synonym name (Here I am using EM as synonym name). If you want to make synonym, private uncheck the Make Public check box. Click OK to create Synonym.
Now your newly created EM synonym and its structure is showing under the Synonym Tab in Schema Browser.
In this post I will show you how to create Synonyms in Oracle Database using TOAD for Oracle.
Connect to Oracle Database using TOAD. Click on Database menu and open Schema Browser
On the Schema Browser open Synonyms Tab and click on New button to create synonym
Create Synonym window will open, select the object type (Here I am creating synonym by using Table object). Find your required Object and move it from Available Objects. Give the synonym name (Here I am using EM as synonym name). If you want to make synonym, private uncheck the Make Public check box. Click OK to create Synonym.
Now your newly created EM synonym and its structure is showing under the Synonym Tab in Schema Browser.
postingan yang bagus tentang How to Create Synonyms in Oracle using TOAD for Oracle
ReplyDeleteHow To Create Synonyms In Oracle Using Toad For Oracle >>>>> Download Now
Delete>>>>> Download Full
How To Create Synonyms In Oracle Using Toad For Oracle >>>>> Download LINK
>>>>> Download Now
How To Create Synonyms In Oracle Using Toad For Oracle >>>>> Download Full
>>>>> Download LINK an
too good piece of information, I had come to know about your site from my friend sajid, bangalore,i have read atleast 11 posts of yours by now, and let me tell you, your web-page gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new post, once again hats off to you! Thanks a lot once again, Regards, Synonyms In Oracle
ReplyDeleteHow To Create Synonyms In Oracle Using Toad For Oracle >>>>> Download Now
ReplyDelete>>>>> Download Full
How To Create Synonyms In Oracle Using Toad For Oracle >>>>> Download LINK
>>>>> Download Now
How To Create Synonyms In Oracle Using Toad For Oracle >>>>> Download Full
>>>>> Download LINK Cy
Great Post!!! thanks for it.
ReplyDeleteadvantages of android application
need of android
Thanks a lot, you made it really easy to understand I have bookmarked this page for my future reference. Do share more updates.
ReplyDeleteJava Training in Chennai
Java Training in Bangalore