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 oracle latest version?
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
20. Using a set operator, display the client number of all clients who have never placed an order.
Maximum how many triggers can be updated in table ?
5 Answers Accenture, Cap Gemini,
Where are the settings stored for each instance in oracle?
How to use an explicit cursor without open statements?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
How to change program global area (pga) in oracle?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Is primary key indexed by default in oracle?
What is Database Buffers ?
What is a deadlock in SQL? How can you prevent it?