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;

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

950

---

Does truncate remove indexes?

978

---

What is difference between cursor and trigger?

1022

---

How many types of tables are there?

910

---

Mention what pl/sql package consists of?

945

---

Is primary key always clustered index?

956

---

What are the different ways to optimize a sql query?

896

---

Can we use two order by clause in query?

929

---

How do I create a sql database?

957

---

Is ms sql traffic encrypted?

881

---

what does it mean to have quoted_identifier on? : Sql dba

1108

---

What is full join?

903

---

What is the trigger in sql?

910

---

What is the function that is used to transfer a pl/sql table log to a database table?

960

---

how tsql statements can be written and submitted to the database engine? : Transact sql

931

---