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 |
How do we accept inputs from user during runtime?
i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.
What is not equal in sql?
Can you create a table with Primary Key not as the clustered index.
What is sql architecture?
Is a foreign key always unique?
explain what is mysql? : Sql dba
Can a table have no primary key?
Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)
what is overloading procedure or overloading function ?
what is the difference between trigger and constraint?
How to run pl sql program in mysql?
Oracle (3253)
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)