Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / basanti
Synonym is an alias for a object of a database.
It can be created for TABLE or VIEW.
There are two type of synonym PRIVATE and PUBLIC.
public synonym is created by a keyword public.
public synonym is accessible to any schema in the database.
Syntax to create public synonym:
CREATE PUBLIC SYNONYM synonym_name FOR object_name;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between open_form and call_form in oracle.
How to write date and time literals in oracle?
How would you go about verifying the network name that the local_listener is currently using?
What is a named program unit?
What is an external table?
Explain the use of rows option in imp command.
material view and view disadvantages?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is a table in oracle?
How do I manually uninstall oracle client?
How to define a cusotmer as a supplier in ORACLE R12
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
How to create a new oracle data file?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to store pictures on to the database?
