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

How to pipe multiline string to isql?

0 Answers  


What is optimistic concurrency control? : Transact sql

0 Answers  


How would you convert date into julian date format?

0 Answers  


Why cannot I use bind variables in ddl/scl statements in dynamic sql?

0 Answers  


What is time based sql injection?

0 Answers  


explain the delete statements in sql

0 Answers  


What are the qualities of 2nf?

0 Answers  


Is primary key is clustered index?

0 Answers  


Write a sql select query that only returns each name only once from a table?

0 Answers  


How do you clear the screen in sql?

0 Answers  


what is error ora-03113: end-of-file on communication channel?

0 Answers  


Explain the difference between rename and alias?

0 Answers  


Categories