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 are the different type of normalization? : Sql dba

1027

---

How many types of normalization are there?

957

---

How do you rename a table in sql?

1105

---

Why do we use triggers?

966

---

what is a trigger in mysql? : Sql dba

1144

---

Is pl sql a programming language?

989

---

Define sql delete statement.

1011

---

How long will it take to learn pl sql?

936

---

What is primary key and foreign key with example?

929

---

What is an exception in pl/sql?

1087

---

What are conditional predicates?

1059

---

where are cookies actually stored on the hard disk? : Sql dba

1029

---

How many subqueries can be nested in a statement?

982

---

Explain mutating table error.

1200

---

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

993

---