Interested to Buy Any Domain ? << Click Here >> for more details...
What are synonyms used for ?
- 3 Answers
- 6858 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 |
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
How to get a list of all user accounts in the database?
Explain coalesce function?
How to filter out duplications in the returning rows using oracle?
how to delete all duplicate records from a table using subquery?
What is truncate oracle?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
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?
How to display row numbers with the records?
What is ASM (Automatic Storage Management) in Oracle?
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
Oracle General 
