select distinct next_day((sysdate-level),'FRI') as fir from dual

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

Question Posted / anish

Answer Posted / anish

select distinct next_day((sysdate-level),'FRI') as fir from dual
connect by level <=(sysdate-to_date('01-Jan-2017','dd-mon-yyyy'))
order by 1 asc

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is system tablespace?

1103

Is there a function to split a string in plsql?

1068

What is ordinary table in oracle?

1163

Why do you use stored procedures and state some of its disadvantages?

1028

Why is oracle database so popular?

1012

How to use group functions in the select clause using oracle?

1076

What are the differences between char and varchar2 in oracle?

1177

How many data types are supported?

1085

What is data file?

1110

How to sort the query output in oracle?

1030

How to create a stored program unit?

1234

What is the difference between 10g OEM and 11g OEM?

969

How a tablespace is related to data files?

1110

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1023

what is difference between sql plus and sql*plus? (not sql and sql plus).

3906