Now, users of other schemas can reference the table called suppliers without having to prefix the table name with the schema named app. This first CREATE SYNONYM example demonstrates how to create a synonym called suppliers. Let's look at an example of how to create a synonym in Oracle.įor example: CREATE PUBLIC SYNONYM suppliers object_name The 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. Inserting objects in MS Word can offer data and other resources to. PUBLIC It means that the synonym is a public synonym and is accessible to all users. Microsoft Word allows you to embed objects created in other programs into one document. The syntax to create a synonym in Oracle is: CREATE SYNONYM synonym_nameįOR object_name dblink] 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. Galactic Nucleus This is another word for the center of a galaxy but in common usage it refers to the visible center of a galaxy external to our Milky Way.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |