Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 )

Answers were Sorted based on User's Feedback



what is the need of the cursor attribute notfound..(because using found attribute we can complete t..

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

what is the need of the cursor attribute notfound..(because using found attribute we can complete t..

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

Post New Answer

More SQL PLSQL Interview Questions

what is a stored procedure? : Sql dba

0 Answers  


What is the purpose of primary key?

0 Answers  


What is character functions?

0 Answers  


diff b/w function and procedure?

9 Answers   iFlex,


What are the benefits of stored procedures?

0 Answers  


Can a procedure in a package be overloaded?

0 Answers   EXL,


Explain two easy sql optimizations.

0 Answers  


What is ttitle and btitle?

0 Answers  


How do I run a sql script?

0 Answers  


What is the full form of sql?

1 Answers  


In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,


How do I run a program in pl sql?

0 Answers  


Categories