What are synonyms used for ?
Answers were Sorted based on User's Feedback
Answer / swapna
Synonyms are used to provide alternate name for a table
permanently.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / annu rajput
Synonym is used to give the global name to the table name
in the database.
In other words we can say that it is the annother
permanent name for
the table.
Thanks
Annu_Rajput
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / nishi
- Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is catalog in Oracle?
candidate key is subset of super key but not vice-verse explain
What is object data modeling?
Explain how are indexes update?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to check the oracle tns settings?
What are the benefits of ordbms?
How to convert characters to numbers in oracle?
Explain a private synonyms?
Explain constraining triggers.
What is a table index in oracle?
In Oracle 10g, "g" Stands for what?