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;

What is a join and explain different types of joins?

2 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 you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

0 Answers  

---

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

0 Answers   IBM,

---

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

0 Answers  

---

Write short notes on XSU and JAVA

1 Answers  

---

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me

1 Answers   IBM,

---

What are the three basic rules which are to be followed for the relational model of the database?

0 Answers  

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

0 Answers  

---

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

0 Answers  

---

Write the difference between case version and decode version.

2 Answers  

---

In which database can extended stored procedures be added?

0 Answers  

---