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

Answer / avi007

pl/sql table -

type table_name is varchar2(25) of index by BINARY_INTEGER

It is having only one column of varchar2

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

Answer / aravinda

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

Answer / karunakarreddy.boyapally

it is a collection of all the schema objects those are
tables,views,triggers,indexes etc....

Answer / menan

a set of SQL commands are known as pl/sql

What is full join?

0 Answers  

What steps server process has to take to execute an update statement?

0 Answers  

What are user defined functions?

0 Answers  

What is output spooling in sql*plus?

0 Answers  

What is $$ in sql?

0 Answers  

What is the difference between function and procedure in pl/sql?

0 Answers  

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

0 Answers  

Mention what are different methods to trace the pl/sql code?

0 Answers  

Is sql considered coding?

0 Answers  

What does where 1 1 mean in sql?

0 Answers  

How is sql used in oracle?

0 Answers  

How do we use distinct statement? What is its use?

0 Answers