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

how the indexes are stored in the Oracle Database?

2331

How to load data through external tables?

1187

Explain oracle insert into command?

1155

What is a named program unit?

1136

What are operators in oracle?

1100

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1975

What is the relation of a user account and a schema in oracle?

1126

Name the three major set of files on disk that compose a database in Oracle?

1170

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

3941

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1095

Explain self joins in oracle?

1058

What are the differences between char and varchar2 in oracle?

1245

Explain about achiever in sql?

1086

What is an oracle table?

1031

Explain integrity constraint?

1206