When a dml statement is executed, in which cursor attributes, the outcome of the

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

Question Posted / ratnakar mishra

1 Answers
1199 Views
I also Faced
E-Mail Answers

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?..

Answer / Yatheesh Kumar

The outcome of a DML (Data Manipulation Language) statement, such as INSERT, UPDATE, or DELETE, is not saved in any cursor attribute. Instead, you can retrieve this information using functions like SQL%ROWCOUNT for the number of rows affected.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers IBM,

What is a temporal data type?

1 Answers

What is the use of pl/sql table?

1 Answers

how to convert numeric values to character strings? : Sql dba

1 Answers

what is the difference between delete and truncate commands? : Sql dba

1 Answers

What is the difference between the conventional and direct path loader? : aql loader

1 Answers

What is pl sql architecture?