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
- 8192 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 |
how to retrieve the top 3 salaries of the table using rownum
What is varchar example?
What are types of exception?
what is the difference between cursor FETCH and FOR LOOP ?
3 Answers CG-VAK, Tech Mahindra,
While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?
How is a process of pl/sql compiled?
What is a subquery in sql?
how many no of table can be join in a sql query.
What is %s in sql?
how to find 5th row ?
Why do we use function in pl sql?
Are stored procedures faster than dynamic sql?
-
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)
