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...

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


Please Help Members By Posting Answers For Below Questions

can a stored procedure call itself or recursive stored procedure? : Sql dba

1023


Can we use pl sql in sql server?

1078


what is schema? : Sql dba

1044


How you improve the performance of sql*loader? : aql loader

1009


What are the steps for performance tuning.

1326


what is a constraint? : Sql dba

1144


What are different methods to trace the pl/sql code?

1115


How to make a copy values from one column to another in sql?

1030


What is a heap in sql?

1059


how to get a list of all tables in a database? : Sql dba

970


What is sql and how does it work?

1162


Which are the different case manipulation functions in sql?

1016


In pl/sql, what is bulk binding, and when/how would it help performance?

987


what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1000


Write a query to display the current date in sql?

1018