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 |
Can select statements be used on views in oracle?
Explain what does a control file contain?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
What is the difference between normal and corelated subqueries?
6. Display the client name and order date for all orders using the traditional method.
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
what r tyhe major differences between oracle 9i & 10g?
please explain.. DB architecture ...
After using set unused can we enable the column again to use? Please give me some answers....
what are the different types of cursors? explain?
How do I find my oracle client driver version?