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 %notfound return null after a fetch?
What does rownum mean in sql?
Why we use joins in sql?
What is the most restrictive isolation level? : Transact sql
Define implicit and explicit cursors.
What is user defined functions?
What is the difference between function and procedure in pl/sql?
Can we create index on primary key?
How is indexing done in search engines?
What is the difference between a database and a relational database?
Why coalesce is used in sql?
what is a trigger in mysql? Define different types of trigger. : Sql dba
How do I remove sql developer from windows 10?
What is a subquery in sql?
What is cte?