What is pl/sql tables?

Answers were Sorted based on User's Feedback



What is pl/sql tables?..

Answer / s

It is a composite datatype used in PLSQL programming.

Is This Answer Correct ?    14 Yes 2 No

What is pl/sql tables?..

Answer / bikash khuntia

Features of PL/SQL tables are as follows –

1) It is a composite data type.
2) They are modeled as similar to database tables, but they
are not permanent tables. So they can be created and
manipulated only in a PL SQL block.
3) They can have only one column but any data type
4) It will have a primary key which is compulsory for the
reference of values
5) There is no name to the column and primary key
6) The data type of the primary key is BINARY_INTEGER.
BINARY_INTEGER is a special data type which can be
given only to the column of PL/SQL table for it’s indexing
purpose to store and retrieve values.
Range of binary_integer is -2147483647 to 2147483647
7) Size is unconstrained (Table size grows as the rows are
added to the table).
8) Can visualize a Pl/SQL table as a single dimensional
vertical array, which can hold unlimited elements.
Suitable for storing and displaying the values of one
column of a table given by a cursor.


Example of PL SQL Table –

Each name from the emp table is given to the vname plsql
table by using cursor. Then those names from vname table
are displayed .

Declare
Type nametable IS TABLE OF CHAR(10) INDEX BY
BINARY_INTEGER;
/*Creating variable vname of nametable type.*/
vname nametable;
Cursor cf is select ename from emp;
i number;
/*i is for the loop and vrows is for displaying the
total names from the vname table*/
Begin
Open cf;
i := 1;
Loop
Fetch cf into vname(i);
/*Transferring each ename into vname table*/
Exit when cf%NotFound;
i := i+1;
End Loop;
Close cf;


/*Now retrieving the names from the vname plsql table using
for loop.*/
For n in 1 .. vname.count
Loop
dbms_output.put_line('Name is '||vname(n));
End Loop;
End;

Is This Answer Correct ?    3 Yes 0 No

What is pl/sql tables?..

Answer / harika

plsql table is a datatype used in cursors,procedures,functions

Is This Answer Correct ?    2 Yes 1 No

What is pl/sql tables?..

Answer / kiran pnr

PL/SQL TABLE is also known as Index by table
These are single-column tables and could be considered as
an Array of data but which is unbounded; i.e we cannot set
a limit on number of rows like an array

Example : TYPE NTab_List1 is TABLE OF TYPE INTEGER

Is This Answer Correct ?    2 Yes 1 No

What is pl/sql tables?..

Answer / vishal

PL/SQl are the scaller arrays used to store data.

Is This Answer Correct ?    0 Yes 1 No

What is pl/sql tables?..

Answer / aravinda

index by tables , nested tables and varrays collectively
called PL/SQl tables.

Is This Answer Correct ?    0 Yes 1 No

What is pl/sql tables?..

Answer / ankit

A table is the basic storage structure of an
RDBMS. A table holds all the data necessary about something
in the real world, such as employees,
invoices, or customers.

Is This Answer Correct ?    4 Yes 6 No

Post New Answer

More SQL PLSQL Interview Questions

Does sql*plus have a pl/sql engine?

0 Answers  


What is sql and db2?

0 Answers  


What will happen after commit statement ?

2 Answers  


What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

3 Answers   TCS,


What is dense_rank in sql?

0 Answers  






How do I view a table in sql?

0 Answers  


How do I know if I have sql express or standard?

0 Answers  


How do I view a view in sql?

0 Answers  


How to start the command-line sql*plus?

0 Answers  


What are transaction and its controls?

0 Answers  


how to rename an existing column in a table? : Sql dba

0 Answers  


How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,


Categories