Let's look at an example of how to create a synonym in Oracle. object_nameThe name of the object for which you are creating the synonym. If this phrase is omitted, Oracle assumes that you are referring to your own schema. Remember though that the user must first have the appropriate privileges to the object to use the synonym. PUBLIC It means that the synonym is a public synonym and is accessible to all users.
The syntax to create a synonym in Oracle is: OR REPLACE Allows you to recreate the synonym (if it already exists) without having to issue a DROP synonym command. You may wish to create a synonym so that users do not have to prefix the table name with the schema name when using the table in a query.
You generally use synonyms when you are granting access to an object from another schema and you don't want the users to have to worry about knowing which schema owns the object. DescriptionĪ synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects. This Oracle tutorial explains how to create and drop synonyms in Oracle with syntax and examples. A synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects.
#DOCSINK CCM MAC OS#
The software is available for Windows, Linux and Mac OS X. Sononym is a sample browser that offers a fresh perspective on how sounds can be explored and organized. Find similar words and phrases with our powerful synonym search engine. Synonym search engine powered by WordHippo. Synonyms And Antonyms Finders Dictionary.For over 20 years, has been helping millions of people improve their mastery of the English language and find the precise word with over 3 million synonyms and antonyms. The world’s largest and most trusted free online thesaurus. Developed from Merriam-Webster dictionary, the most trustworthy authority on American English. Synonyms, antonyms, definitions, and example sentences help you find the right word quickly. Make your writing more interesting, beautiful, and successful.
0 kommentar(er)
