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 the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2093

What is memory advisor in Oracle?

1042

Explain temporal data types in oracle

1054

How to create a server parameter file?

1095

How to save query output to a local file?

988

What are a query and state the different types of queries and their uses?

971

How to check the oracle tns settings?

1006

How to put more than 1000 values into an oracle in clause?

992

What happens if you set the sga too low in oracle?

1079

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2006

what is a Nested Loop join?

2057

What is the difference between $oracle_base and $oracle_home?

1052

What are the tools for Oracle ?

1027

What is object data modeling?

916

What are the uses of a database trigger?

949