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'

How to start your 10g xe server?

0 Answers  

---

query optmization techniques and quwry analyser+projects+ppts

0 Answers  

---

What different of iner joint & outer joint with example

4 Answers  

---

What is the difference between alert log file and trace file ?

1 Answers  

---

How to get a list of all background sessions in the database?

0 Answers  

---

---

how to retrieve daily sal from emp table in oracle 10g

2 Answers   Infosys,

---

how to handle exceptions in post production

0 Answers  

---

How to get execution statistics reports on query statements?

0 Answers  

---

What is difference between truncate and delete?

0 Answers  

---

What is null value in oracle?

0 Answers  

---

What happens if recursive calls get out of control?

0 Answers  

---

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 Answers  

---