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
How to create a stored program unit?
What is oracle in java?
How to define an anonymous procedure without variables?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to calculate date and time differences in oracle?
What is a cognitive schema?
Difference between pre-select and pre-query
What are the differences between date and timestamp in oracle?
Explain what are the type of synonyms?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
Explain self joins in oracle?
How to export your connection information to a file?
Explain the use of file option in exp command.
How to display row numbers with the records?
What are the system predefined user roles?
