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 to assign a table row to a record variable?

582

Can we insert data in view oracle?

541

How to call a stored function in oracle?

574

Can we save images in a database and if yes, how?

594

Explain cascading triggers.

574

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

862

How to concatenate two text values in oracle?

593

Can group functions be used in the order by clause in oracle?

580

Oracle

1857

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

653

What are the types of partitions in oracle?

543

How to delete all rows a table in oracle?

625

How to convert dates to characters in oracle?

584

Explain oracle data types with examples?

577

How to manage transaction isolation level?

564