What is PL/SQL table ?

Answers were Sorted based on User's Feedback



What is PL/SQL table ?..

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

What is PL/SQL table ?..

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

What is PL/SQL table ?..

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

What is PL/SQL table ?..

Answer / aravinda

index by tables , nested table and varrays collectively
called are called PL/SQL tables.

Is This Answer Correct ?    0 Yes 2 No

What is PL/SQL table ?..

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 PL/SQL table ?..

Answer / menan

a set of SQL commands are known as pl/sql

Is This Answer Correct ?    1 Yes 8 No

Post New Answer

More SQL PLSQL Interview Questions

what is External tables? explain with examples

2 Answers   TCS,


List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,


What are its different types of dbms?

0 Answers  


When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,


How do I count rows in sql query?

0 Answers  






How many types of triggers are there in pl sql?

0 Answers  


define sql

3 Answers   Zensar,


how to calculate expressions with sql statements? : Sql dba

0 Answers  


What is a natural join?

0 Answers  


Explain alias in sql?

0 Answers  


what is “go” in t-sql? : Transact sql

0 Answers  


What are the different types of tables in sql?

0 Answers  


Categories