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

Explain the use of rows option in exp command.

577

Briefly explain what is literal? Give an example where it can be used?

532

How to end the current transaction in oracle?

541

How a tablespace is related to data files?

573

What is a trace file and how is it created in oracle?

542

Is java required for oracle client?

541

How to rollback the current transaction in oracle?

533

How does one get the view definition of fixed views/tables?

590

Why do we need oracle client?

504

What are dml statements in oracle?

609

Is oracle a language?

512

How to test null values?

667

What is Segment Advisor in Oracle?

661

How can we find out the duplicate values in an oracle table?

600

How to list all user accounts in oracle?

603