Answer / 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

Answer / mahima

use @@rowcount

Answer / shail

If using SQL*PLUS then use

set feedback on

Answer / pkd

Except sql%rowcount,using returning clause with count()
function

Give the Types of modules in a form?

1 Answers  

---

Can we create more than one constraint to column ?

6 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

What are the ways tablespaces can be managed and how do they differ?

0 Answers  

---

what is the use of composite key constraint?

2 Answers  

---

without using count(*) and rownum how can we count total record in a table

5 Answers   AC, HP,

---

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

4 Answers   Microsoft,

---

Why is oracle so popular?

0 Answers  

---

How to create a temporary table in oracle?

0 Answers  

---

Without giving condition how to retrieve the unmatched records from table.

1 Answers   TCS,

---

What privilege is needed for a user to query tables in another schema?

0 Answers  

---

what are different types of locks?

6 Answers  

---