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
7435 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 operating systems are supported by oracle sql developer?

903

what are myisam tables? : Sql dba

951

What is a sql instance vs database?

1036

What is sql table?

903

How do I view a procedure in sql?

908

what is text? : Sql dba

1007

what are the advantages of sql ? : Sql dba

999

What is gpt format?

894

What does count (*) mean?

873

Why are sql stored procedures used?

988

How to start the command-line sql*plus?

998

How do I write a sql query in pgadmin 4?

924

Explain the purpose of %type and %rowtype data types?

875

explain commit and rollback in mysql : sql dba

937

What is trigger types in sql?

942