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 you delete a table?

989

---

What are sql objects?

1011

---

What is sql partition function?

1113

---

Explain what is a database?

1033

---

What is int identity in sql?

1055

---

Why partition by is used in sql?

963

---

How much does sql cost?

927

---

How do I find duplicates in the same column?

996

---

How to run pl sql program in mysql?

938

---

What are the two types of exceptions in pl/sql?

962

---

How do I restart sql?

910

---

Can we use update in sql function?

1003

---

Can we rollback truncate?

940

---

What is Materialized View? In What Scenario we Use Materialized View?

9392

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1005

---