How to build data dictionary view an new database?

0 Answers  

---

What is the difference between Outer join and Full outer join?

5 Answers  

---

What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?

4 Answers   Microsoft, Wipro,

---

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,

---

How to rename a column in an existing table?

0 Answers  

---

---

Difference between join and a subquery?

8 Answers   Base Automation, NMDC,

---

What are the set operators union, union all, minus & intersect meant to do?

0 Answers  

---

Why do we need oracle client?

0 Answers  

---

how to retrieve data from different tables ,place this data in different excel worksheets.

1 Answers   Gap Inc,

---

How do you bind variables in oracle?

0 Answers  

---

What is the scope of a local variable?

0 Answers  

---

How to find the duplicate rows count from employees table in oracle?

0 Answers  

---