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 are the cursor attributes used in PL/SQL ?

Question Posted / guest

Answers were Sorted based on User's Feedback



What are the cursor attributes used in PL/SQL ?..

Answer / rajesh

The cursor attributes are
%rowcount
%found
%notfound
%isopen
if u have any issue contact me at
rajesh.natesh@gmail.com,rajesh.natesh@cognizant.com

Is This Answer Correct ?    8 Yes 0 No

What are the cursor attributes used in PL/SQL ?..

Answer / pandu

Hi,
Cursor Attributes
1)Isopen
2)Found
3)Not Found
4)rowCount

but ,we cursor's are two types
Namely 1)Implicit Cursor
calling the attibutes as SQL%ISOPEN
2)Explicit cursor
calling the Attiributes as CursoName%ISOPEN.

Is This Answer Correct ?    8 Yes 0 No

What are the cursor attributes used in PL/SQL ?..

Answer / nishi

The cursor attributes are

%rowcount

%found

%notfound

%isopen

Is This Answer Correct ?    0 Yes 0 No

What are the cursor attributes used in PL/SQL ?..

Answer / gireesh.p.v

%type
%rowtype
contact me gireesh.p.v@gmail.com

Is This Answer Correct ?    1 Yes 8 No

Post New Answer

More SQL PLSQL Interview Questions

What are views in sql?

0 Answers  

how to present a past time in hours, minutes and seconds? : Sql dba

0 Answers  

What is pl sql and why it is used for?

0 Answers  

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

5 Answers   Cap Gemini,

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,

What is sql analyzer?

0 Answers  

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  

Explain the difference between triggers and constraints?

0 Answers  

Give which cursor is better for better performance means type of cursors?

2 Answers  

What are pl/sql exceptions? Tell me any three.

1 Answers  

how will u find statistics of a database objects?

2 Answers   iFlex,

For more SQL PLSQL Interview Questions Click Here
Categories