Interested to Buy Any Domain ? << Click Here >> for more details...
what is the need of the cursor attribute notfound..(because
using found attribute we can complete the task......found +
negation operator = not found )
- 2 Answers
- 8008 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
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 is a crud api?
What is sql performance tuning?
What is bulk collections?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is string data type in sql?
how to rename an existing column in a table? : Sql dba
Delete the emps whose salaries are lowest sals of their own dept.
When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?
2 Answers Accenture, Unisoft Infotech,
What is null in pl/sql?
Explain the advantages and disadvantages of stored procedure?
How do I install sql?
What is the difference between having clause and where clause?
-
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)
