select daten, to_char(daten,'DY') dayn from ( select to

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

Question Posted / colarif

5 Answers
6275 Views
Flipkart, HCL, TCS, I also Faced
E-Mail Answers

Answer Posted / colarif

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is oracle the best database?

915

Can we create trigger on materialized view in oracle?

941

What is null value in oracle?

1037

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2056

Explain rename?

925

Give syntax for SQL and ORACLE joins.

1042

What is where clause in oracle?

982

How to convert csv to table in oracle?

924

How do I learn what codesets are available in oracle?

998

How to create a table interactively?

999

State and explain about oracle instance?

930

Please explain drop constraint oracle?

1029

How to count duplicated values in a column in oracle?

985

How to list all indexes in your schema?

1033

How does one get the view definition of fixed views/tables?

969