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
- 8037 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 are the features of pl sql?
Why are sql stored procedures used?
Can we use more than one null value for unique key?
31 Answers A1 Technology, Wipro,
Can we insert delete data in view?
Mention what does the hierarchical profiler does?
what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
Which function is used to return remainder in a division operator in sql?
what is online transaction processing (oltp)? : Sql dba
what is innodb? : Sql dba
What are the different ddl commands in sql?
What is the best strategy to use COMMIT in a pl/sql loop?
what is a composite primary key ? : Sql dba
-
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)
