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
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How to store only time; not date and time?
How to create a single index for multiple columns?
What is a Garbage Collection? and what is full recursive Garbage collection?
Explain the difference between a procedure and a function? What do you understand by those terms?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to install oracle odbc drivers?
What is meant by raw datatype?
Why does Oracle not permit the use of PCTUSED with indexes?
What do you mean by redo log file mirroring?
What is a system tablespace and when it is created?
How do I uninstall oracle 11g?
Explain the features of oracle?
How to connect to a local oracle 10g xe server?
