How to display all Friday's in a year with date?
Answer Posted / dinesh
CREATE OR REPLACE PROCEDURE display_day_date(c date,d date,v varchar2) IS
a number(10);
m date:=c;
BEGIN
a:=d-m;
FOR i in 1..a
LOOP
IF to_char(m,'DY')= v THEN
DBMS_OUTPUT.PUT_LINE('THIS IS'||' '|| v ||' ' || 'DATE for the year '||' '||to_char(m,'yyyy')|| ' '|| m);
END IF;
m:=m+1;
END loop;
END;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is orm in sql?
What are different types of keys?
What are the disadvantages of not performing database normalization?
How do I remove duplicates in two columns?
Differentiate between sga and pga.
What does plv msg allows you to do?
What is interval partition?
How to display the records between two range in Oracle SQL Plus?
What is rank dense_rank and partition in sql?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is trigger in sql? Explain
What is the cause of mutating table error and how can we solve it?
What are the benefits of stored procedures?
How does one load ebcdic data? : aql loader
Is it possible to read/write files to-and-from PL/SQL?