what are pl/sql collections?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / praveenkumar
collection is set of ordered group of elements, all of the
same type.
Is This Answer Correct ? | 15 Yes | 2 No |
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 |
Why is %isopen always false for an implicit cursor?
Is keyword pl sql?
oracle is compiler or interpretter,can any one tell me the answer?
Why self join is used in sql?
What is primary and foreign key?
How many levels can subqueries be nested in a FROM clause?
how to return query output in html format? : Sql dba
how to insert the records in particular position
how can you create an empty table from an existing table? : Sql dba
Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --
What does trigger mean in psychology?
What are the types of triggers in sql?