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

Which command is used to delete a trigger?

0 Answers  

When should I use nosql database?

0 Answers  

Is null operator in sql?

0 Answers  

Explain polymorphism in pl/sql.

0 Answers  

in a package one procedure is wrong package shows valid or not

4 Answers  

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

24 Answers   Accenture, HCL, Infosys,

What are the different datatypes available in PL/SQL?

0 Answers  

how mysql optimizes distinct? : Sql dba

0 Answers  

How do I view a sql database?

0 Answers  

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

What is the sql query to display the current date?

0 Answers  

What are Anti joins

1 Answers   IBM,

For more SQL PLSQL Interview Questions Click Here
Categories