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


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

Post New Answer

More SQL PLSQL Interview Questions

What are commit, rollback, and savepoint?

0 Answers  


When would you denormalize?

8 Answers   MBT, Microsoft, MMU,


How can you create an empty table from an existing table?

0 Answers  


Why do we use procedures?

0 Answers  


what is a tablespace? : Sql dba

0 Answers  


What is the difference between an inner and outer join?

0 Answers  


what is csv? : Sql dba

0 Answers  


Explain the commit statement.

0 Answers  


Can we have two clustered index on a table?

0 Answers  


What is union and union all keyword in sql and what are their differences?

0 Answers  


Why primary key is required?

0 Answers  


How to select 10 records from a table?

0 Answers  


Categories