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

Can we change the table name in sql?

950

what is a primary key? : Sql dba

1043

What is indexing oracle sql?

1111

What does truncate mean in sql?

1036

What is the difference between delete and truncate commands?

1050

What is recursive join in sql?

1035

What are the types of join in sql?

1109

What are the benefits of pl/sql packages?

1110

How to Declare Fixed Length String Value In PL SQL

1159

How do I make sql search faster?

1004

What is pivot in sql?

919

What is trigger in pl sql with examples?

1055

What are pl/sql packages?

1107

What are the possible values for the boolean data field?

971

what is msql? : Sql dba

994