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 the difference between sql and t-sql? : Transact sql

0 Answers  

how to convert dates to character strings? : Sql dba

0 Answers  

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,

what does the t-sql command ident_current does? : Transact sql

0 Answers  

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

What is type and rowtype in pl sql?

0 Answers  

how can i read files from a pl/sq l program

3 Answers  

Is id a reserved word in sql?

0 Answers  

What is a trigger in pl/sql?

1 Answers  

How does a self join work?

0 Answers  

What is Collation Sensitivity ? What are the various type ?

0 Answers