Interested to Buy Any Domain ? << Click Here >> for more details...
What are synonyms used for ?
- 3 Answers
- 6969 Views
- I also Faced
- E-Mail Answers
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 a proxy class?
How can you use check constraints for self referential integrity?
When do I need to use a semicolon vs a slash in oracle sql?
What happens to the data files if a tablespace is dropped?
How to bring a tablespace online?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
query optmization techniques and quwry analyser+projects+ppts
What to do if dba lost the system password?
What is clusters ?
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
How to define an anonymous procedure without variables?
Oracle General 
