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
6273 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 grant create session privilege to a user in oracle?

948

What is the difference between substr & instr functions?

1123

Explain oracle insert into command?

1056

What are the advantages of oracle?

963

What is a lookup table in oracle?

934

Difference between cartesian join and cross join?

959

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1012

Explain the difference between a procedure and a function? What do you understand by those terms?

1023

How will you identify oracle database software release?

944

What is oracle in java?

913

How to shutdown your 10g xe server?

1083

Explain coalesce function?

1119

How to use "in" parameter properly?

1006

Whether any commands are used for months calculation? If so, what are they?

1042

What is memory advisor in Oracle?

1027