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 advantages of VIEW?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What is a full join sql?
Is foreign key mandatory?
How do I view stored procedures?
Is nosql relational?
find the third highest salary?
List the various privileges that a user can grant to another user?
tell me about various levels of constraint. : Sql dba
what are myisam tables? : Sql dba
what is the difference between char_length and length? : Sql dba
What does stand for in sql?