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;

Explain about post-relational databases?

0 Answers  

---

How to use online Backups?

0 Answers  

---

How can I detect whether a given connection is blocked?

0 Answers  

---

What is the physical representation for a many-to-many relationship?

0 Answers  

---

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  

---

How you can make a parameterized view?

0 Answers  

---

Explain about relational operator join?

0 Answers  

---

how will I find the duplicate rows count from employees tablein oracle.

2 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,

---

agregator gives one to many records or many to one record

1 Answers   IBM,

---

What is a join and explain different types of joins?

2 Answers  

---

How is data stored in dbms?

0 Answers  

---