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 want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
What is Data Dictionary Cache in Oracle?
a query to select maxmun 3 salaries of employee table
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
Please explain drop constraint oracle?
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
What is a parameter file in oracle?
What is a trigger and what are its types?
State some uses of redo log files?