What is Private Database Link ?
Answer / orawhiz
Private database link is created on behalf of a specific user.
A private database link can be used only when the owner of
the link specifies a global object name in a SQL statement
or in the definition of the owner's views or procedures.
| Is This Answer Correct ? | 1 Yes | 0 No |
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
what is the use of system.effective.date variable in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
How to pass parameters to procedures?
structural difference between bitmap and btree index ?
How to Select second Maximum salary in a Table ?
What is blob data type in oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Explain the blob datatype?
Can we call procedure inside function in oracle?
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
What is a Sequence ?