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 is External tables? explain with examples
List the differences between plsql - function & procedures
What are its different types of dbms?
When we give SELECT * FROM EMP; How does oracle respond?
24 Answers Accenture, HCL, Infosys,
How do I count rows in sql query?
How many types of triggers are there in pl sql?
define sql
how to calculate expressions with sql statements? : Sql dba
What is a natural join?
Explain alias in sql?
what is “go” in t-sql? : Transact sql
What are the different types of tables in sql?