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 |
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.
what is reindexing?
How to use "startup" command to start default instance?
What is an oracle tablespace?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How many memory layers are in the shared pool?
How translate command is different from replace?
can we insert any row to dual table if i got the permission from DBA
What is execute immediate in oracle?
What are the most common interview questions on ETL Testing for experience?
What is a proxy object?
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.