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 does the sign mean in sql?
is it possible to pass an object or table to a procedure as an argument?
What does truncate mean in sql?
what is bulk bind
I have a table .in the table 100 recored is there .we have get the single row with out using clause..
Explain about various levels of constraint.
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
what are the 'mysql' command line arguments? : Sql dba
Can we use loop in sql?
What is the use of <> sql?
Is sql better than access?
What is the difference between anonymous block and named block or stored procedure?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)