What is TRUE about %ROWCOUNT in PL/SQL Cursor?

84. What is TRUE about %ROWCOUNT in PL/SQL Cursor?

  1. A SELECT INTO statement or DML statements like INSERT, DELETE, AND UPDATE do not result in any rows being affected.
  2. Results are returned for DML statements such as inserting, deleting, and updating records, or for those returned by a SELECT INTO command.
  3. Both A. and B.
  4. None of the above

Answer: B) Results are returned for DML statements such as inserting, deleting, and updating records, or for those returned by a SELECT INTO command

Explanation:

Results are returned for DML statements such as inserting, deleting, and updating records, or for those returned by a SELECT INTO command.


Comments and Discussions!





Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.