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

What is oracle update statement with inner join ?

1116

What is an Oracle index?

1702

why dont we assign not null constraint as table level constraint.

2797

how to handle exceptions in post production

1486

How to use select statement to count the number of rows in oracle?

1092

what is the difference between substr and instr function in oracle?

1143

What is a tns service name?

1058

How to define an oracle sub procedure?

1232

What are the different editions of oracle?

1179

How to shutdown your 10g xe server from command line?

1153

what are the default admin accounts in Oracle 10g ?

1024

What is oracle rowcount?

1147

Explain about your project and its relation to the current job position you are applying to?

1078

How to do clean up if create database failed?

1071

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2288