select * from ( SELECT (TRUNC (SYSDATE, 'yyyy') + LEVEL

How to display all Friday's in a year with date?

Question Posted / kuldeep

4 Answers
7785 Views
Flipkart, I also Faced
E-Mail Answers

Answer Posted / kuldeep

select * from
(

SELECT (TRUNC (SYSDATE, 'yyyy') + LEVEL - 1) dt,
TRIM(TO_CHAR ((TRUNC (SYSDATE, 'yyyy') + LEVEL - 1), 'Day')) dy
FROM DUAL
CONNECT BY LEVEL <= 365

)
where dy='Friday'

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is not null constraint? : Sql dba

1078

Can we use commit inside a trigger?

1147

Explain the uses of database trigger.

1179

What are the 3 types of behavioral triggers?

1314

What is the difference between sql and t sql?

1107

What is a schema sql?

1228

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

1019

What do you mean by query optimization?

1051

Why is there a need for sqlcode and sqlerrm variables?

1104

Mention what are the benefits of pl/sql packages?

1159

What are the types of keys?

1067

What is an ndf file?

1067

What do you mean by dbms? What are its different types?

1066

How to call a javascript function from pl sql?

1187

Can we use ddl statements in stored procedure sql server?

1064