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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is the need of the cursor attribute notfound..(because
using found attribute we can complete the task......found +
negation operator = not found )

Question Posted / mirchsarao

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 the difference between RDBMS and DBMS?

20 Answers   Practical Viva Questions, Sapient, Stag Computers,

What is tuple in sql?

0 Answers  

What is crud sql?

0 Answers  

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

Can %notfound return null after a fetch?

0 Answers  

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers  

What type of database is sql?

0 Answers  

how to use case expression? : Sql dba

0 Answers  

How do I find duplicates in sql?

0 Answers  

How do I create an index in word?

0 Answers  

How do you declare a variable in pl sql?

0 Answers  

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

For more SQL PLSQL Interview Questions Click Here
Categories