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

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

Question Posted / kuldeep

4 Answers
7441 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

How to install oracle sql developer?

986

What is a primary key sql?

991

What is a dirty read sql?

1035

What is sqlca in powerbuilder?

956

what is a database lock ? : Sql dba

1093

How can we store rows in PL/SQL using array?

1162

How do you sort in sql?

954

How many tables can you join in sql?

901

Why cross join is used?

1024

What is rtm in testing?

1040

How is a process of pl/sql compiled?

1087

What does truncate mean in sql?

964

How do I edit a stored procedure?

949

How do I find duplicates in the same column?

1000

which operator is used in query for pattern matching? : Sql dba

949