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 trigger and what are its types?

1330

How do we display rows from the table without duplicates?

1019

How would you go about verifying the network name that the local_listener is currently using?

2110

1) Does oracle have any table which contain all the exceptions and it's code internally?

1806

What are the different pseudo commands? Explain in general?

1126

How do I limit the number of rows returned by an oracle query after ordering?

1228

How many memory layers are in the oracle shared pool?

1256

What is a database table in oracle?

1071

Will you be able to store pictures in the database?explain.

1040

Are truncate and delete commands same? If so why?

1204

What is meant by a deadlock situation?

1156

What is object data modeling?

1017

How view is different from a table?

1089

What are the roles of dba?

1137

What are the predefined tablespaces in a database?

1145