What is PL/SQL table ?
Answers were Sorted based on User's Feedback
Answer / firefly
An associative array (or INDEX-BY table) that can be
indexed by NUMBER or VARCHAR2. Elements are retrieved using
number or string subscript values. Unlike with data tables,
PL/SQL tables are stored in memory. PL/SQL Tables are
sparse and elements are unordered
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / avi007
pl/sql table -
type table_name is varchar2(25) of index by BINARY_INTEGER
It is having only one column of varchar2
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sree
pl/sql tables are temporary array like objects in pl/sql
block.pl/sql tables have one column and one primary key.the
size of pl/sql tables unconstrained i.e the number of rows
can be increased by dynamically
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / aravinda
index by tables , nested table and varrays collectively
called are called PL/SQL tables.
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / karunakarreddy.boyapally
it is a collection of all the schema objects those are
tables,views,triggers,indexes etc....
Is This Answer Correct ? | 0 Yes | 4 No |
what are the types of join and explain each? : Sql dba
How do you explain an index number?
what does it mean to have quoted_identifier on? : Sql dba
What is difference between sql and excel?
Do we need to create index on primary key?
How to set up sql*plus output format in oracle?
which tcp/ip port does sql server run on? : Sql dba
What is data abstraction in sql?
Does mysql support pl sql?
What is mutating trigger?How to avoid it??
What are the indexing methods?
how to install mysql? : Sql dba