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 |
How to find out what oracle odbc drivers are installed?
How do I start tns listener?
How do I call oracle stored procedures that take no parameters?
How does one get the view definition of fixed views/tables?
Explain the relationship among Database, Tablespace and Data file?
How to rename an index?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
am completed mca2011 how get certification in oracle
What are the extensions used by oracle reports?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is an oracle user role?
What happens if recursive calls get out of control?