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 control file used for?
how to find count rows in table without count function?
How to put more than 1000 values into an oracle in clause?
How to create a new table in oracle?
How to write an inner join with the where clause in oracle?
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
What is a subquery?
Explain parameter file in oracle.
What are cursor?where are they used?
what is the difference between simple view and complex view?
what is data independence exactly? give an example
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.