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.

Can select statements be used on views in oracle?

0 Answers  

---

Explain what does a control file contain?

0 Answers  

---

two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)

2 Answers  

---

What is the difference between normal and corelated subqueries?

2 Answers  

---

6. Display the client name and order date for all orders using the traditional method.

0 Answers   Wipro,

---

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

1 Answers   KPIT,

---

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?

0 Answers   Sierra Atlantica,

---

what r tyhe major differences between oracle 9i & 10g?

6 Answers  

---

please explain.. DB architecture ...

0 Answers  

---

After using set unused can we enable the column again to use? Please give me some answers....

1 Answers   Maveric,

---

what are the different types of cursors? explain?

4 Answers  

---

How do I find my oracle client driver version?

0 Answers  

---