difference between pl/sql table and normal pl/sql table

Answers were Sorted based on User's Feedback



difference between pl/sql table and normal pl/sql table..

Answer / 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

difference between pl/sql table and normal pl/sql table..

Answer / heena

pl/sql tables are not store in database but normal pl/sql
tables are stored in database

Is This Answer Correct ?    7 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

what are rollup and cube in t-sql? : Transact sql

0 Answers  


Mention what are different methods to trace the pl/sql code?

0 Answers  


How do sql triggers work?

0 Answers  


Is sql the best database?

0 Answers  


Define implicit and explicit cursors.

0 Answers  






What is sql deadlock?

0 Answers  


What is oracle sql developer?

0 Answers  


How many disk partitions should I have?

0 Answers  


what is a cursor

9 Answers   IBM, TCS, Wipro,


Why do we use set serveroutput on?

0 Answers  


What are the different ddl commands in sql?

0 Answers  


Is a foreign key always unique?

0 Answers  


Categories