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 not equal to in oracle?
sql query to get zero records from a table
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
ABOUT IDENTITY?
What are the different types of modules in oracle forms?
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
what is the output of select * from emp where null=null & select * from emp where 1=1
how to find count rows in table without count function?
Please explain oracle data types with examples?
How can we find out the duplicate values in an oracle table?
Explain the dml?
How do I spool in oracle?