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;

How do I create a sql database?

1055

---

how to drop an existing table in mysql? : Sql dba

1092

---

define sql insert statement ? : Sql dba

1080

---

what is the difference between primary key and unique key? : Sql dba

1085

---

What is the difference between microsoft sql and mysql?

1017

---

What do you think about pl/sql?

1122

---

What is triggering circuit?

1105

---

What is microsoft t sql?

985

---

What is the use of procedures?

1015

---

Name three sql operations that perform a sort.

1063

---

how can we optimize or increase the speed of a mysql select query? : Sql dba

988

---

How can a pl sql block be executed?

1001

---

Is primary key is clustered index?

1042

---

What are the rules to be applied to nulls whilst doing comparisons?

1367

---

Mention what are the benefits of pl/sql packages?

1155

---