what is the need of the cursor attribute notfound..(because
using found attribute we can complete the task......found +
negation operator = not found )

Answer Posted / babu

The notfound attribute as far as i know is being used to
set the exit condition for the cursor.Yes,found with
negation like NOT(c1%found) can be used instead of notfound.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to fix oracle error ora-00942: table or view does not exist

569


What does sql stand for?

545


What is a constraint? Tell me about its various levels.

638


Is it possible to sort a column using a column alias?

605


How do I partition in sql?

538






Can ddl statements be used in pl/sql?

594


Can we use loop in sql?

537


What is the difference between delete and truncate statement in sql?

497


Is join same as left join?

531


What is on delete set null?

570


How do I tune a sql query?

514


Is foreign key mandatory?

556


How do I remove sql plus from windows 10?

568


What is aggregate function in sql?

537


How would you reference column values before and after you have inserted and deleted triggers?

622