difference between pl/sql table and normal pl/sql table
Answer Posted / hitendra yadav
(1) Simple table store in the database as a object but
PL/SQL or index by table does not store in the database it
can be create only in PL/SQL block.
(2) Simple table in the database can have more then
multiple column up to 254 but index by table can only have
two column first is primary key column of BINARY_INTEGER
and second column is any collection type column.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
can a stored procedure call itself or recursive stored procedure? : Sql dba
Can we use pl sql in sql server?
what is schema? : Sql dba
How you improve the performance of sql*loader? : aql loader
What are the steps for performance tuning.
what is a constraint? : Sql dba
What are different methods to trace the pl/sql code?
How to make a copy values from one column to another in sql?
What is a heap in sql?
how to get a list of all tables in a database? : Sql dba
What is sql and how does it work?
Which are the different case manipulation functions in sql?
In pl/sql, what is bulk binding, and when/how would it help performance?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Write a query to display the current date in sql?