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 basic structure of pl sql?

0 Answers  

List and explain the different types of join clauses supported in ansi-standard sql?

0 Answers  

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

What is a cursor for loop ?

4 Answers  

What is delimiter sql?

0 Answers  

How can you select unique records from a table?

0 Answers  

Why do we create views in sql?

0 Answers  

Explain the methods used to protect source code of pl/sql.

0 Answers  

What are records give examples?

0 Answers  

What is the use of a view in sql?

0 Answers  

Explain what is table in a database?

0 Answers  

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

0 Answers