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
Can multiple columns be used in group by in oracle?
Why should I use oracle database?
What is a sub query? Describe its types?
When do you get a .pll extension in oracle? Explain its importance
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to define a record variable to store a table row?
What is enter substitution variable in oracle?
what is reindexing?
What is an oracle transaction?
State and explain the different types of data models?
Explain coalesce function?
What are the components of logical database structure in oracle database?
Explain the use of parfile option in exp command.
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
When do I need to use a semicolon vs a slash in oracle sql?