SELECT A_DATE, TO_CHAR(A_DATE,'DY') FROM ( SELECT TO

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

Question Posted / basanti meher

5 Answers
4780 Views
Flipkart, HCL, TCS, I also Faced
E-Mail Answers

Answer Posted / basanti meher

SELECT A_DATE, TO_CHAR(A_DATE,'DY')
FROM
(
SELECT TO_DATE('01-JAN-2016','DD-MON-YYYY')+LEVEL-1 A_DATE
FROM DUAL
CONNECT BY LEVEL <= (366)
)
WHERE TO_CHAR(A_DATE,'DY') = 'FRI'

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a dynamic performance view in oracle?

596

Explain the use of online redo log files in oracle.

575

How many categories of data types?

570

How to create a server parameter file?

566

How to convert numbers to characters in oracle?

582

What is the difference between sharding and replication?

473

How to use "while" statements in oracle?

729

Is there an oracle sql query that aggregates multiple rows into one row?

539

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1685

When do you get a .pll extension in oracle?

671

Explain the use of file option in exp command.

591

How would you change old and new values in an insert, delete and update triggers?

537

How to rollback the current transaction in oracle?

534

How do I limit the number of oracle database connections generated by weblogic server?

541

how can we store any pdf file in oracle

1630