Answer Posted / kiran pnr
PL/SQL TABLE is also known as Index by table
These are single-column tables and could be considered as
an Array of data but which is unbounded; i.e we cannot set
a limit on number of rows like an array
Example : TYPE NTab_List1 is TABLE OF TYPE INTEGER
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of cursors in pl/sql?
Explain scalar functions in sql?
What are the different types of joins in sql?
How many row comparison operators are used while working with a subquery?
What is a behavioral trigger?
What is rownum?
What is rowid in sql?
How to select 10 records from a table?
What are the three pl sql block types?
What is scalar function?
What is the sql query to display the current date?
What is union?
How does left join work in sql?
How do you use collections in procedure to return the resultset?
What is the difference between delete and truncate commands?
