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 normalization? Explain different levels of normalization?

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

---

How can I detect whether a given connection is blocked?

0 Answers  

---

What are cursors? Explain different types of cursors?

6 Answers  

---

What is a self join? Explain it with an example?

16 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  

---

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  

---

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  

---

Which data type cannot be used as a parameter in a udf?

0 Answers  

---

can you give me the syntax of named procedure??

2 Answers  

---

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

0 Answers  

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

0 Answers  

---

What is an application role and explain a scenario when you would use one?

0 Answers  

---