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 |
i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID
How data locks are respected in oracle?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
Can we insert data in view oracle?
What are the execution control statements?
Is it possible to enter only time value into a column of a table in sql?
can any one help me with import/export options in oracle............
Explain the importance of .pll extension in oracle?
What is the exact use of Collections?
How to connect to oracle using service name instead of sid?
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
What are Schema Objects ?