Answer Posted / sushmita pathak

Whenever we work with explicit and implicit cursors
(including cursor variables), PL/SQL provides a set of
cursor attributes that return information about the cursor.
PL/SQL 8.1 adds another, composite attribute, SQL%
BULK_ROWCOUNT, for use with or after the FORALL statement.
All of the current attributes are as follows

cur %FOUND:
Returns TRUE if the last FETCH found a row

cur %NOTFOUND:
Returns FALSE if the last FETCH found a row

cur %ISOPEN:
Returns TRUE if the specified cursor is open

cur %ROWCOUNT:
Returns the number of rows modified by the DML statement

SQL%BULK_ROWCOUNT:
Returns the number of rows processed for each execution of
the bulk DML operation


In these attributes, cur is the name of an explicit cursor,
a cursor variable, or the string "SQL" for implicit cursors
(UPDATE, DELETE, and INSERT statements, since none of the
attributes can be applied to an implicit query). The %
BULK_ROWCOUNT structure has the same semantics as an index-
by table. The n th row in this pseudo index-by table stores
the number of rows processed by the n th execution of the
DML operation in the FORALL statement.

What are drivers available?

981

---

How to set NULL values in JDBC PreparedStatement?

938

---

Name different methods for getting streams.

933

---

How can we retrieve data from the resultset?

925

---

Why do you use a data source object for a connection?

984

---

What are the three parts of a jdbc url?

977

---

What does the jdbc databasemetadata interface?

933

---

What protocol does jdbc use?

931

---

How can you use preparedstatement in jdbc?

941

---

What is serialization and deserialization in java programming?

927

---

Explain how data flows from view to db and reverse

2004

---

Describe how the jdbc application works.

978

---

Can I get a null resultset?

963

---

Does jdbctemplate use prepared statements?

869

---

What does the jdbc resultsetmetadata interface?

898

---