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
6511 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

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

1163

What is raw datatype?

1132

What is bulk collect in oracle?

994

What is logical backup in oracle?

1014

Which is faster join or subquery in oracle?

984

What is index in Oracle?

1068

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2336

How to pass a parameter to a cursor in oracle?

1172

How to use "in out" parameter properly?

1044

How to empty your oracle recycle bin?

1017

How to store pictures on to the database?

967

What is connection pooling in oracle?

964

How to call a sub procedure?

1089

What is connection pool in oracle?

984

How to view the data files in the current database?

1094