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
what is self join and what is the requirement of self join? : Sql dba
Which operator is used in query for pattern matching?
what is online transaction processing (oltp)? : Sql dba
What is bitemporal narrowing?
What is the use of partition by in sql?
What is a unique key?
What are the ways on commenting in a pl/sql code?
What is coalesce sql?
What is the difference between nested table and varray?
What is the difference between in and between in sql?
how can we optimize or increase the speed of a mysql select query? : Sql dba
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is crud diagram?
How do you determine the current isolation level? : Transact sql
When to use inner join and left join?