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
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
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
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.
What is the difference between Delete, Truncate and Drop in Oracle?
Explain the use of parfile option in exp command.
How to use "out" parameter properly?
20. Using a set operator, display the client number of all clients who have never placed an order.
How to turn on or off recycle bin for the instance?
How to start your 10g xe server?
How to insert a new row into a table in oracle?
What is transport network substrate (tns) in oracle?
What happens to the indexes if a table is recovered?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to set up autotrace for a user account?