adspace


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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Can delete statement be rollbacked?

1054


how to start mysql server? : Sql dba

1267


What is your daily office routine?

2346


what is sql server agent? : Sql dba

1182


define sql insert statement ? : Sql dba

1098


what is schema? : Sql dba

1147


Can we use distinct and group by together?

1133


what is bcp? When does it used? : Sql dba

1056


If a cursor is open, how can we find in a pl/sql block?

1238


what are aggregate and scalar functions? : Sql dba

1129


What is the current version of postgresql?

1178


what is dbms? : Sql dba

1061


what are all the common sql function? : Sql dba

1131


Is primary key clustered index?

1019


Is inner join faster than left join?

1276