Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 sqlca in powerbuilder?

0 Answers  

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 Answers   HCL,

How can i insert data inro a table with 3 columns using FORALL?

2 Answers   Oracle,

How do I run sql profiler?

0 Answers  

What are the differences between Database Trigger and Integrity constraints ?

4 Answers  

Is sql similar to python?

0 Answers  

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

Are sql views compiled?

1 Answers  

Do we need commit after truncate?

0 Answers  

what are the advantages a stored procedure? : Sql dba

0 Answers  

Is subquery faster than join?

0 Answers  

How do I remove sql developer from windows 10?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories