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
What do you understand by pl/sql records?
What is blind sql injection?
How do I install microsoft sql?
What is the use of partition by in sql?
Why do we use view in sql?
How many types of triggers exist in pl/sql?
Can you do multiple joins in sql?
What is sql and how does it work?
what are the different index configurations a table can have? : Sql dba
what is clause? : Sql dba
What is a null value?
What is null in pl/sql?
Explain what is rdbms?
What are the different sql commands?
How many clustered indexes can be created on a table?