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  

---

Write short notes on manual refreshes.

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,

---

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

0 Answers  

---

What are the 18 schemas?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

0 Answers  

---

Explain about normal forms?

0 Answers  

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

0 Answers  

---

Can you have a nested transaction?

1 Answers  

---

What is DB Development software?

0 Answers  

---

What is an extended stored procedure?

1 Answers  

---

what is Normalization?

6 Answers   TCS,

---