DECLARE c date:='01-JAN-15'; d date:='31-DEC-15';

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

Question Posted / dinesh

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

Answer Posted / dinesh

DECLARE
c date:='01-JAN-15';
d date:='31-DEC-15';
a number(10);
BEGIN
a:=d-c;
FOR i in 1..a
LOOP
IF to_char(c,'DY')='FRI' THEN
DBMS_OUTPUT.PUT_LINE('THIS IS FRIDAY DATE:='|| ' '|| c);
END IF;
c:=c+1;
END loop;
END;

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is table? : Sql dba

1109

What do you mean by field in sql?

1130

how to concatenate two character strings? : Sql dba

1162

Explain how exception handling is done in advance pl/sql?

1047

What is cold data?

1015

How do I filter in sql profiler?

1055

How to get list of all tables from a database?

1212

What is dynamic query?

1036

What are reports usually used for?

1085

explain normalization concept? : Sql dba

1091

how to fetch common records from two tables? : Sql dba

1254

how do you know the version of your mysql server? : Sql dba

1048

What is the difference among union, minus and intersect?

1049

What will you get by the cursor attribute sql%notfound?

1131

How to know the last executed procedure?

1157