what is the need of the cursor attribute notfound..(because
using found attribute we can complete the task......found +
negation operator = not found )
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What packages(if any) has oracle provided for use by developers?
What is the difference between delete, truncate and drop command?
Are subqueries better than joins?
What are conditional predicates?
tell me about various levels of constraint. : Sql dba
What does inner join mean?
What is difference between stored procedure and trigger?
When do we create bitmap indexes
What is trigger in sql and its types?
How can I get the number of records affected by a stored procedure?
What is the usage of when clause in trigger?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)