1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

write a query that displays every Friday in a year with date?

Question Posted / colarif

Answer Posted / colarif

select daten, to_char(daten,'DY') dayn from
( select to_date('31-dec-15') + level daten from dual
connect by level <= 366)
where to_char(daten,'DY') = 'FRI'
and to_char(daten,'YYYY') = 2016;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how are indexes update?

613

What is an Oracle index?

1165

Which is faster join or subquery in oracle?

524

Why does Oracle not permit the use of PCTUSED with indexes?

1942

How to manage transaction isolation level?

548




Is oracle the best database?

509

Explain the function of optimizer in oracle?

583

How to rollback the current transaction in oracle?

532

Is oracle an open source?

627

How to compare dates in oracle sql?

646

What privilege is needed for a user to connect to oracle server?

547

What is the scope of a local variable?

575

Why should I use oracle database?

562

How to define an anonymous procedure without variables?

541

What is the recommended interval at which to run statspack snapshots, and why?

2428