Answer / manoj

DECLARE
v_date DATE;
v_char VARCHAR2(10);
v_number NUMBER;
BEGIN
NULL;
END;

Answer / anuram

CREATE OR REPLACE PROCEDURE PROCEDURENAME{(PARAMETERSLIST)}
AUTHID|CURRENT_USER
IS/AS
DECLARATION OF VARIABLES;
BEGIN
STATEMENTS;
EXCEPTION
STATEMENTS;
END PROCEDURENAME;

In which table collections errors are stored.

0 Answers  

---

What is DB Development software?

0 Answers  

---

What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?

5 Answers   IBM,

---

What is a database development?

0 Answers  

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

0 Answers  

---

---

how will I find the duplicate rows count from employees tablein oracle.

2 Answers  

---

What are triggers? How many triggers you can have on a table?

2 Answers   Ramco,

---

Which four data types cannot be used as a return type from a user-defined function?

0 Answers  

---

In which database can extended stored procedures be added?

0 Answers  

---

How can you fix a poorly performing query?

0 Answers  

---

How to customize error conditions.

0 Answers  

---

Explain the family trees and connection by clause.

1 Answers  

---