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

How to use transactions efficiently : transact sql

0 Answers  

What is hibernate and its relation to sql?

0 Answers  

What is the location of pre_defined_functions.

0 Answers  

what is an alias command? : Sql dba

0 Answers  

Explain the PL/SQL compilation process.

3 Answers  

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

0 Answers  

What is the maximum number of triggers,can apply to a single table?

2 Answers  

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 Answers  

What is java sql package?

0 Answers  

How to use distinct and count in sql query? Explain

0 Answers