Interview Questions Answers in Oracle General

arif mahmud

{ City } freehold
< Country > usa
* Profession * developer
User No # 114867

Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 0

Questions / { arif mahmud }

Questions Answers Category Views Company eMail

Answers / { arif mahmud }

Question { HCL, 6276 }

write a query that displays every Friday in a year with date?

Answer

select daten, to_char(daten,'DY') dayn from
( select to_date('31-dec-15') + level daten from dual
connect by level <= 366)
where to_char(daten,'DY') = 'FRI'
and to_char(daten,'YYYY') = 2016;

Is This Answer Correct ?

1 Yes

0 No