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 are the 18 schemas?

0 Answers  

---

fact table and dimension table containg one to many relationship or many to one relastionship

0 Answers  

---

What is dbms and its application?

0 Answers  

---

Explain the role of indexing in databases?

0 Answers  

---

Explain about xml databases?

0 Answers  

---

I have a few records all are same structures data, I want to store data in multiple targets how

0 Answers   CTR, Infosys, Polaris,

---

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  

---

Explain about relational operator join?

0 Answers  

---

What is the system function to get the current user's user id?

4 Answers  

---

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

3 Answers  

---

How long can an error message be in raiseerror function?

0 Answers  

---