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 |
In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.
10 Answers HCL, TCS,
In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?
What is the interface?
q)what are the validations in sql*loader
How many standard interface programs in oracle purchasing module and oracle inventory? What are they?
What are the User PARAMETERS in the Reports?
What is SRW Package? (Sql Report Writer)
do i need to declare bind parameter before using in the query?
How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?
What is the link between AP and GL in oracle apps R/12?
4 Answers Bosch, Collabera, Synechron,
do you know is it possible to run the interface without using oracle apps?
Hi all I am in big career dilemma. I am currently working as Oracle Apps functional consultant scm with 1 yr of exp. I am thinking to do mba. Hos it will work to di MBA in scm or operations. Please guide .