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;

How to use online Backups?

0 Answers  

---

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

0 Answers   TCS,

---

What are data modelling techniques?

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 are the three types of database design?

0 Answers  

---

---

In which table collections errors are stored.

0 Answers  

---

Where is dbms used?

0 Answers  

---

How to customize error conditions.

0 Answers  

---

What are the key features of dbms?

0 Answers  

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

0 Answers  

---

Explain the general syntax for a SELECT statements covering all the options.

3 Answers  

---

Who are end users in dbms?

0 Answers  

---