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
6709 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 to do daily transactions with out sql* loader control file regesterd in apps?

1733

What is format trigger?

2121

How to drop a stored procedure in oracle?

1106

Explain a private synonyms?

1097

How to create lov dynamically at runtime & attach to text field?

1240

How does oracle handle read consistency?

1153

What do you mean by a tablespace?

1092

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1098

Why should I use oracle database?

1049

How to create a new table in your schema?

1130

Respected sir, Please send me technical questions related to oracle apps..

1868

What are the limitations of check constraint?

1076

How many memory layers are in the oracle shared pool?

1256

What are the differences between char and varchar2 in oracle?

1249

Is there a function to split a string in plsql?

1109