Answer / nit

use sql%rowcount after each statement

Answer / hairreddy

by using cursor attribute cursorname%rowcount we can find how many records fetched

What is sql prepared statement?

0 Answers  

---

How delete all data from all tables in sql?

0 Answers  

---

What are the parameter modes supported by pl/sql?

0 Answers  

---

Why sql query is slow?

0 Answers  

---

wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure

3 Answers   Apollo,

---

what is data manipulation language? : Sql dba

0 Answers  

---

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,

---

What are pl sql data types?

0 Answers  

---

What is scalar function?

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

What is an exception in PL/SQL? What are the two types of exceptions?

0 Answers  

---

What is sql table?

0 Answers  

---