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;

Can an extended stored procedure be called from inside a user-defined function?

0 Answers  

---

What are the 18 schemas?

0 Answers  

---

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

3 Answers  

---

Can you instantiate a COM object by using T-SQL?

1 Answers  

---

What is normalization? Explain different levels of normalization?

8 Answers   CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

---

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,

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

0 Answers  

---

What is a database development?

0 Answers  

---

How to read and create .LDC data files which are used by linguatic dictionary.

0 Answers  

---

How to generate OIDS

0 Answers  

---

Can you have a nested transaction?

1 Answers  

---

Explain the process of the user request and data generating?

0 Answers  

---