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

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

Question Posted / ranjan

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

Answer Posted / ranjan

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

Is This Answer Correct ?

11 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

1009

Can we connect to ORACLE db using Windows Authentication?

1196

Explain the importance of .pll extension in oracle?

962

How to do clean up if create database failed?

987

How to start a specific oracle instance?

1006

How to get execution path reports on query statements?

943

How to empty your oracle recycle bin?

994

How to delete a column in an existing table?

1030

What do you know about normalization? Explain in detail?

892

What is the difference between Delete, Truncate and Drop in Oracle?

1085

What are joins, explain all types of joins?

2233

Please explain oracle data types with examples?

1008

Is postgres faster than oracle?

980

What is where clause in oracle?

992

is there a tool to trace queries, like profiler for sql server?

1098