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 are triggers and its uses?

0 Answers  

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

Explain the concept of normalization.

3 Answers  

how u can find the n row from a table?

19 Answers   Tech Mahindra,

Difference between views and materialized views?

5 Answers   BirlaSoft,

What is data type in sql?

0 Answers  

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

What are the possible values that can be stored in a boolean data field?

0 Answers  

Can primary key be changed?

0 Answers  

What is primary key secondary key alternate key candidate key?

0 Answers  

What is trigger in sql and its types?

0 Answers  

what is difference between "Primary key" and "Unique key"?

4 Answers   PreVator,