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
What is an oracle user role?
How to view all columns in an existing table?
What is hot backup and logical backup?
How to call a stored function in oracle?
What are the restrictions on external table columns?
What happens to the current transaction if the session is ended?
What are dml statements in oracle?
How to get a list of all background sessions in the database?
How to retrieve data from an explicit cursor?
Explain integrity constraint?
What are the differences between primary key and unique key?
Explain an index segment?
What are the roles of dba?
Is primary key indexed by default in oracle?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.