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

1. is it possible to use the cursor atttibutes (%found ,%
rowcount , %isopen , %notfound ) to our user defined cursor
names .......



cursor cursor_name is select * from scott.emp



if you use...



cursor_name%found , %rowcount ,%isopen,%notfound...will it
work...

--------------------------





2.what is the difference between the varray and index by
table ..



--------



3.

type type_name is table of number(8,3)

index by binary_integer;

identifier_name type_name;



first , last , prior , next ,trim are the methods we can
use it for the above type...simillary is there any way to
apply for cursors...

with thanks and regards..sarao...

Question Posted / sweetsarao

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

3 Answers   TCS,

What are different types of tables in sql?

0 Answers  

What are the types of variables use in pl sql?

0 Answers  

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,

Which data type doesn't allow null data type?

6 Answers   TCS,

What are the operators used in select statements?

0 Answers  

Give me some examples of predefined exceptions.

3 Answers  

What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,

How to return multiple rows from the stored procedure?

0 Answers  

What is the difference between joins?

0 Answers  

what is variable in package specification

3 Answers  

How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,

For more SQL PLSQL Interview Questions Click Here
Categories