\nWritten a PL\/SQL loop, you need to test if the current FETCH was successful. Which SQL cursor attribute would you use to accomplish this task?<\/p>\n
\nA:<\/strong> SQL%ISOPEN \nANSWER: C<\/strong><\/p>\n \nEXPLANATION: Answer C is correct because of SQL%FOUND attribute returns TRUE if current FETCH have been successful.<\/strong><\/p>\n \nINCORRECT ANSWERS:<\/p>\n \nA:<\/strong> SQL%ISOPEN attribute returns TRUE if cursor is OPEN and ready for use. Written a PL\/SQL loop, you need to test if the current FETCH was successful. Which SQL cursor attribute would you use to accomplish this task? A: SQL%ISOPEN B: SQL%ROWCOUNT C: SQL%FOUND D: This task cannot be accomplished with a SQL cursor attribute. E: A SQL cursor attribute cannot be used within a PL\/SQL loop. ANSWER: […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,13,8],"tags":[],"class_list":["post-822","post","type-post","status-publish","format-standard","hentry","category-1z0-001","category-oca-plsql-developer","category-oracle"],"_links":{"self":[{"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=\/wp\/v2\/posts\/822","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=822"}],"version-history":[{"count":0,"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=\/wp\/v2\/posts\/822\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=822"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=822"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nB:<\/strong> SQL%ROWCOUNT
\nC:<\/strong> SQL%FOUND
\nD:<\/strong> This task cannot be accomplished with a SQL cursor attribute.
\nE:<\/strong> A SQL cursor attribute cannot be used within a PL\/SQL loop.<\/p>\n
\nB:<\/strong> SQL%ROWCOUNT returns the number of rows that were processed by the statement.
\nD:<\/strong> This task can be successfully accomplished with a SQL%FOUND cursor attribute.
\nE:<\/strong> PL\/SQL loop can contain a SQL cursor attribute.<\/p>\n","protected":false},"excerpt":{"rendered":"