Updating fetch in plsql zune card not updating

Posted by / 25-Sep-2017 08:14

Updating fetch in plsql

works fine when I try to update all the records in tbl A, however, in this case I only have missing data which I have identified and populated in tbl B.

But since the UPDATE has no WHERE clause, it will update all rows, even those where the subquery returns NULL.The database cursor characteristic of traversal makes cursors akin to the programming language concept of iterator.Cursors are used by database programmers to process individual rows returned by database system queries.He is a Senior Consultant and Managing Partner at B.Watkins, a database consulting and training firm in the Dallas / Fort Worth area.

updating fetch in plsql-40updating fetch in plsql-73updating fetch in plsql-79

A cursor can be viewed as a pointer to one row in a set of rows.