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 / manoranjan sethy

As per as cursor attribute concept are concern %notfound attributes are used in order of to terminate the condition.

Using found with negation like not (c1%found) we can even exit from the condition but instead of writing %NOTFOUND attribute why should I use unnecessarily two operator (like, not)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to create a new view in mysql? : Sql dba

498


how can we optimize or increase the speed of a mysql select query? : Sql dba

506


What is t sql in sql server?

572


Which normal form is best?

515


Does mysql support pl sql?

624






What does select top 1 do in sql?

544


What is bulk collect in pl sql?

533


Can we insert data into materialized view?

518


What will you get by the cursor attribute sql%found?

537


What is the maximum size of sqlite database?

548


What is sql and db2?

535


What are sql built in functions?

510


When to use inner join and left join?

526


What is dense_rank?

540


What are the three pl sql block types?

571