Answer / 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');

Answer / nagaraju

select count(*) from (
select trunc(to_date(sysdate,'DD/MM/rrrr'),'mm') +rownum -1 dates
from dual connect by level <=Add_Months(trunc(to_date(sysdate,'DD/MM/rrrr'),'mm'),1) - trunc(to_date(sysdate,'DD/MM/rrrr'),'mm')
)
where
to_char(dates,'DY')='SAT'

What is forall Statement ?

2 Answers   Thermotech,

---

difference between imlicit cursor and explicit cursor ?

5 Answers   Cap Gemini,

---

What is use of oracle?

2 Answers   Satyam,

---

How to connect to the server with user account: sys?

0 Answers  

---

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

1 Answers   Gap Inc,

---

What are inner join and outer join?

3 Answers  

---

select trunc(round(156.00,-1),-1) from dual;

2 Answers  

---

Explain the use of indexes option in imp command.

0 Answers  

---

What is the difference between pre-select and pre-query?

0 Answers  

---

How to do a full database export?

0 Answers  

---

How to create a table interactively?

0 Answers  

---

How to sort output in descending order in oracle?

0 Answers  

---