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
Why we use bulk collect in oracle?
What are the differences between number and binary_float in oracle?
What do you mean by redo log file mirroring?
What is oracle datasource?
What are the common oracle dba tasks?
What is oracle used for?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how the indexes are stored in the Oracle Database?
How to define a cusotmer as a supplier in ORACLE R12
How to pass a cursor variable to a procedure?
How to run queries on external tables?
Is postgres faster than oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is index-organized table in Oracle?
How can I see all tables in oracle?
