Answer Posted / anuradha

Select Count(*)
From (Select Trunc(To_Date('20120305', 'yyyymmdd'), 'MM')
+ Rownum - 1 Dates
From (Select 1 From Dual Group By Cube(2, 2, 2,
2, 2))
Where Rownum <=
Add_Months(Trunc(To_Date
('20120305', 'YYYYMMDD'), 'MM'), 1) -
Trunc(To_Date('20120305', 'YYYYMMDD'), 'MM'))
Where To_Char(Dates, 'DY') In ('SAT');

How to manage transaction isolation level?

962

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2913

---

How to store only time; not date and time?

978

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2143

---

What is define in oracle?

1025

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4514

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2089

---

Which is faster join or subquery in oracle?

947

---

How to drop an index in oracle?

1033

---

How to omit columns with default values in insert statement in oracle?

1016

---

How do I know if oracle client is installed on windows?

975

---

How data locks are respected in oracle?

1025

---

Is truncate autocommit in oracle?

1045

---

What is an external table?

971

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2345

---