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

Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,

How to check if a column is nullable before setting to nullable?

0 Answers  

what is the difference between clustered and non clustered index in sql? : Sql dba

0 Answers  

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

4 Answers   Scope International,

What is the order of sql select?

0 Answers  

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

write a query to delete similar records in different tables with same structure

4 Answers  

What are the data types allowed in a table?

3 Answers  

What is a package ? What are the advantages of packages ?

2 Answers   Symphony,

Why schema is used in sql?

0 Answers  

What is auto increment in sql?

0 Answers  

What is Overloading of procedures ?

4 Answers   Amdocs,

For more SQL PLSQL Interview Questions Click Here
Categories