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 a Garbage Collection? and what is full recursive Garbage collection?

2897

Name the various constraints used in oracle?

1011

Explain parameter file in oracle.

1021

How to execute a stored procedure in oracle?

1078

What is the usage of merge statement?

1142

What is difference between sid and service name in oracle?

950

What is the difference between a primary key & a unique key?

1086

Explain the use of parfile option in exp command.

1063

What is oracle open database communication (odbc)?

1022

How to use subqueries with the exists operator in oracle?

1022

What is the difference between I and G in Oracle?

1092

How to grant create session privilege to a user in oracle?

995

What's dateware house and what's clustor with practicle example

2168

how to join query for one source type is oracle another source type is sql server ?

2425

What is oracle and what are its different editions?

1064