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 schema means?
How to write a query to show the details of a student from students table whose
How can I pass the inner procedure value to outer procedure ?
Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
How do I copy a table in sql?
What is TABLE SPACE?
Explain table and field in sql?
What is function and procedure in pl sql?
which tcp/ip port does sql server run on? : Sql dba
How to copy a table in another table with datas?
what is try_catch block in procedure
What is int identity in sql?
Oracle (3253)
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)