Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / arpitha2206

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 is rank () in sql?

0 Answers  

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

Which is better stored procedure or query?

0 Answers  

What is a native sql query?

0 Answers  

what are sequences

0 Answers  




How many types of indexes are there in sql?

0 Answers  

Name some usages of database trigger?

0 Answers  

what is an associative array with example?

1 Answers  

Can you do multiple joins in sql?

0 Answers  

When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

What packages(if any) has oracle provided for use by developers?

1 Answers  

What are stored procedures in mysql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories