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
- 8146 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 global variable in package
What version is sql?
What is foreign key and example?
Explain the difference in execution of triggers and stored procedures?
what are date and time functions in mysql? : Sql dba
Explain lock escalation? : Transact sql
What is the maximum rows in csv?
In what condition is it good to disable a trigger?
How many levels can subqueries be nested in a FROM clause?
Explian rowid, rownum? What are the psoducolumns we have?
Is ms sql is free?
Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?
-
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)
