What is Public Database Link ?
Answer / orawhiz
Public database link is created for the special user group
PUBLIC.
A public database link can be used when any user in the
associated database specifies a global object name in a SQL
statement or object definition.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can we convert a date to char in oracle and if so, what would be the syntax?
What is columnar storage what is the advantage?
List out the components of logical database structure of oracle database.
Are truncate and delete commands same? If so why?
Explain the use of rows option in imp command.
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What is the usage of save points in oracle database?
what is difference between where clause and having clause?
Who developed oracle & when?
What the is the diff between local index and global index. give some example.
What is pragma autonomous transaction in oracle?
what is cartesian product?