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

Why does for update in oracle 8 cause an ora-01002 error?

932

How to insert multiple rows with one insert statement in oracle?

1020

How to convert numbers to characters in oracle?

967

What is the quickest way to export a table to a flat file?

918

How to use "in" parameter properly?

1002

What is a proxy object?

1008

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1955

What is translate in oracle?

1049

What happens to indexes if you drop a table?

1107

What is background process in Oracle?

1050

What is ordinary table in oracle?

1074

Is there a function to split a string in plsql?

981

How to connect to oracle using service name instead of sid?

963

How to grant create session privilege to a user in oracle?

946

What is proxy method?

929