why we can use synonym?
Answers were Sorted based on User's Feedback
Answer / srinivasa reddy k
We use synonym generally to hide the base schema name in
which the object lies, as well as it is easy to use.
Is This Answer Correct ? | 22 Yes | 2 No |
Answer / archana patil
Synonyms are an alternative name to table, to which we can
give perticular grants, so that main definition get hides
and as per grant it can be accessed.
Is This Answer Correct ? | 12 Yes | 2 No |
Answer / mohan kumar
SYNONYM-USING SYNONYM WE CAN EASILY ACCESS TO A TABLE OWNED
BY ANOTHER USER.IT SHORTENS THE LENGTHY OBJECT NAMES
Is This Answer Correct ? | 9 Yes | 5 No |
Answer / ramesh babu v
For security purpose of the table.other person can't
modifying the database table
Is This Answer Correct ? | 4 Yes | 2 No |
to save memory also we can use synonyms, y bcz its not
accupy any memory ok
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rama rao
It shorten the lenthy schema.It hide the information for
unauthorized persons and it reduce the time,memory consume.
In your aplication what we need to hide the information
that time is requried.
Is This Answer Correct ? | 0 Yes | 0 No |
What are the files you have used in the part of Conversion and Interfaces?
What is the use of format trigger?
Can 2 functions have same name & input parameters but differ only by return datatype ?
how to set org context?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
How to insert data into two tables using single control file?
Tell me where we find the status of order information?
In support project one ticket alloted which steps follows manualy tell me ?
List the various types of value set.
What is profile and what is level of profile option and it's hierarchy
what are the tables of auto invoice.
In sequence i want to 11 and 15th values how we will write?