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 / sivareddy

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

Answer Posted / sivareddy

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 <= to_date('31-dec-2016','dd-mon-yyyy') - TO_DATE('01-JAN-2016','DD-MON-YYYY')+1)
WHERE TO_CHAR(C_DATE,'DY') = 'FRI'
/

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the attributes of the cursor?

996

What are operators in oracle?

1053

How to omit columns with default values in insert statement in oracle?

1044

How to select some rows from a table in oracle?

1072

How do we get field details of a table?

978

Explain cascading triggers.

1068

How to write a query with a left outer join in oracle?

1061

What is oracle open database communication (odbc)?

1022

How to load a large xml file?

1049

Explain the difference between sql and oracle?

1072

What happens if you lost a data file?

1034

What are the different windows events activated at runtime ?

2896

How to define a data field as not null?

1103

How to get a list of all user accounts in the database?

1085

What is PL/SQL ?

2047