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 the location of pre_defined_functions.

0 Answers  

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  

Does a user_objects view have an entry for a trigger?

0 Answers  

What is group by in sql?

0 Answers  

How many sql databases can you have on one server?

0 Answers  




When the mutating error will comes? and how it will be resolved?

2 Answers  

What does partition by mean in sql?

0 Answers  

What is index example?

0 Answers  

Can you load data into multiple tables at once? : aql loader

0 Answers  

How many unique keys can a table have?

0 Answers  

What is a join?

0 Answers  

write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories