Interested to Buy Any Domain ? << Click Here >> for more details...
How to find no of saturdays in a month using single sql ?
- 2 Answers
- 5687 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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');
| Is This Answer Correct ? | 1 Yes | 0 No |
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'
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the different types of cursors? explain?
What are the different type of Segments ?
How do I recompile a procedure in oracle?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What is a snapshot log?
Explain how are indexes update?
How to retrieve the count of updated rows?
Explain the use of tables option in exp command.
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
How to do clean up if create database failed?
what are archived logs?
Oracle General 
