how many columns can a plsql table have

Answer Posted / susil kumar rout

Generally pl/sql table can create at the run time.
It is virtual table contains 2 columns
1-binary index.
2-data type upon which pl/sql table is created.
example-
Type typename is table of emp.ename%type
index by binary_integer;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1796


What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

893


21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1834


What is the difference between Delete, Truncate and Drop in Oracle?

877


Explain the use of parfile option in exp command.

765


How to use "out" parameter properly?

846


20. Using a set operator, display the client number of all clients who have never placed an order.

1995


How to turn on or off recycle bin for the instance?

846


How to start your 10g xe server?

804


How to insert a new row into a table in oracle?

864


What is transport network substrate (tns) in oracle?

811


What happens to the indexes if a table is recovered?

785


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2346


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

799


How to set up autotrace for a user account?

806