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

List out the difference between commit, rollback, and savepoint?

1005

List out the components of logical database structure of oracle database.

1007

How to start a new transaction in oracle?

1049

what is the dual table in oracle?

949

What is a trigger oracle?

1056

What is the usage of analyze command in oracle?

1053

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

964

What the is the diff between local index and global index. give some example.

1599

State all possible different index configurations a table can possibly have?

960

How to define a data field as not null?

1079

Why does Oracle not permit the use of PCTUSED with indexes?

2392

How to write an inner join with the where clause in oracle?

1022

How to assign a tablespace to a users in oracle?

1013

Can group functions be used in the order by clause in oracle?

956

What is the Tune Query

2250