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 |
where we will put the control file ,where we will run sql star loader what is the cmd?
how to use .prt file in bitmap reports?
which API to return the parameters & valuesets etc
why we can use synonym?
what is difference between po_headers_all and po_headers
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1
List the various types of value set.
Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports
in reports token is casesensitive or not?
What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter
Are you familiar with internet architecture of oracle apps 11i?