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 |
Explain raise_application_error.
How do I edit a stored procedure?
What is a join query?
Explain character-manipulation functions?
What is the use of <> sql?
Does view contain data?
What is natural join in sql?
Explain spool.
when is the use of update_statistics command? : Sql dba
What are the usages of sql?
I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.
explain mysql aggregate functions. : Sql dba