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

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

Question Posted / kuldeep

4 Answers
7624 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 does sql developer connect to oracle database?

1009

Is json a nosql?

985

What is difference between sql function and stored procedure?

1013

When sql appeared?

1106

What is rowtype?

1028

What is the difference between join and natural join?

937

Is progress software supports to ( pl/sql )?

1043

What is pl sql block structure?

1045

What are the parts of a basic sql query?

983

tell me about various levels of constraint. : Sql dba

1041

What is a trigger word?

1032

What is normalization sql?

1066

How to execute a stored procedure?

1100

Is full outer join same as cross join?

978

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

963