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;

What does bitemporal mean?

1067

---

What is sqlcontext?

1085

---

Explain normalization and what are the advantages of it?

953

---

Can procedure in package be overloaded?

1085

---

Why is a trigger used?

943

---

Can we use insert statement in function?

1003

---

What is the use of function "module procedure" in pl/sql?

1198

---

What is clustered and nonclustered index in sql?

944

---

what is meant by nl2br()? : Sql dba

1046

---

what are the properties and different types of sub-queries? : Sql dba

1034

---

tell me about various levels of constraint. : Sql dba

1035

---

What is the difference between join and natural join?

927

---

How to return an array from java to pl/sql?

1143

---

What are the benefits of stored procedures?

1074

---

What is cursor and why it is required?

1183

---