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 pl/sql collections?

Question Posted / dibya

Answers were Sorted based on User's Feedback



what are pl/sql collections?..

Answer / pradeep

A collection is an ordered group of elements, all of the
same type. It is a general concept that encompasses lists,
arrays, and other familiar datatypes. Each element has a
unique subscript that determines its position in the collection.

PL/SQL offers these collection types:

* Index-by tables,
* Nested tables
* Varrays

Is This Answer Correct ?    50 Yes 2 No

what are pl/sql collections?..

Answer / hannan oca

collection of similar datatypes or group of same datatypes
are called collections.Basically they are 3 types
1.Index-by tables,
2.Nested tables
3.Varrays
collection of different datatypes are known as Records.

Is This Answer Correct ?    15 Yes 1 No

what are pl/sql collections?..

Answer / praveenkumar

collection is set of ordered group of elements, all of the
same type.

Is This Answer Correct ?    15 Yes 2 No

what are pl/sql collections?..

Answer / debanjan rudra

pl/sql collections are temporary table types which helps
the programmer to "temporary" manipulate data comprising
more than 1 row (i.e. not scalar).

Eg. CREATE OR REPLACE TAB AS TABLE OF VARCHAR2(100) INDEX
BY PLS_INTEGER;

In the above example "TAB" is a collection which shall be
used to temporarily store more than 1 varchar2 records.

Is This Answer Correct ?    8 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

What is rownum?

0 Answers  

What are pl/sql cursors?

0 Answers  

What are pl sql procedures?

0 Answers  

Explain alias in sql?

0 Answers  

What is record in pl sql?

0 Answers  

Does sql support programming?

0 Answers  

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  

is mysql query is case sensitive? : Sql dba

0 Answers  

What is the clause we need to add in function body to return variable?

0 Answers  

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

What is AUTH_ID and AUTH_USER in pl/sql ?

0 Answers   INDUS,

what are the 'mysql' command line arguments? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories