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
7593 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 rownum in sql?

1043

what is bcp? When is it used?

1105

explain mysql aggregate functions. : Sql dba

984

What are the different type of joins in sql?

951

How do I restart sql?

965

What are all ddl commands?

1080

What is full join in sql?

987

What is normalization in sql?

1009

what are the 'mysql' command line arguments? : Sql dba

1136

I need a function for a train ticket reservation please answer it thanks in advance

1024

Can we create view in stored procedure?

955

what is the difference between join and union? : Sql dba

1111

What is the use of stored procedures?

1044

How to write a query to show the details of a student from students table whose

994

what is a view? : Sql dba

1081