Answer Posted / svj

Using SQL Cursor Attribute,'SQL%ROWCOUNT' which gives
no.of rows affected by the most recentSQL statement (an
integer value), one can know no.of records got updated.

For Example :

VARIABLE rows_updated VARCHAR(30)
DECALRE
v_dept_no departments.department_id%TYPE := 20
BEGIN
UPDATE employees
SET salary = salary + 1000
WHERE department_id = v_dept_no;
: rows_updated := (SQL%ROWCOUNT || 'rows updated.');
END;
/
PRINT rows_updated

Differentiate between function and procedure in oracle.

1049

---

Differentiate between post-database commit and post-form commit?

1008

---

Difference between hot backup vs. Cold backup?

968

---

Explain drop constraint oracle?

1030

---

How to bring a tablespace offline?

1045

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1975

---

What are the attributes of cursor?

1031

---

How to rename an index?

1047

---

How to start your 10g xe server from command line?

1051

---

Does oracle database need java?

980

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5500

---

How to handle a single quote in oracle sql?

1012

---

How to assign a table row to a record variable?

1009

---

Is the After report trigger fired if the report execution fails ?

2900

---

Why we use bulk collect in oracle?

1011

---