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
- 8287 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 are rank and dense rank being alloted for column with same values over a particular column
What is pl sql architecture?
give the syntax of grant and revoke commands? : Sql dba
Advantages and disadvantages of stored procedure?
how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.
What is pessimistic concurrency control? : Transact sql
Can I join the same table twice?
What are the advantages of sql?
What are different types of tables in sql?
What is the source code of a program?
What is rank dense_rank and partition in sql?
What does pl sql developer do?
-
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)
