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;

Write short notes on manual refreshes.

0 Answers  

---

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

0 Answers  

---

State the acid rules?

0 Answers  

---

What are cursors? Explain different types of cursors?

6 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  

---

what is difference between primary key and unique key ?

2 Answers  

---

Explain the cube operator?

0 Answers  

---

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

0 Answers  

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

0 Answers  

---

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

0 Answers  

---

What is DB Development software?

0 Answers  

---