Explain view?

0 Answers  

---

Explain the use of tables option in exp command.

0 Answers  

---

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 Answers  

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

0 Answers   IBM,

---

Find all employees in Dept “Marketing”.

2 Answers  

---

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

What is the exact use of Collections?

0 Answers  

---

Explain temporal data types in oracle

0 Answers  

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

0 Answers  

---

Describe an oracle table?

0 Answers  

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---

What is Undo Management Advisor in Oracle?

0 Answers   MCN Solutions,

---