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

Does normalization improve performance?

0 Answers  

What is pessimistic concurrency control? : Transact sql

0 Answers  

How many functions are there in sql?

0 Answers  

Which sql most popular?

0 Answers  

Can we use join in subquery?

0 Answers  

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

What is the result, when NULL is compared with NULL?

22 Answers   TCS,

How many commands are there in sql?

0 Answers  

What are instead of triggers?

0 Answers  

What is function and procedure in pl sql?

0 Answers  

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,