Interested to Buy Any Domain ? << Click Here >> for more details...
difference between pl/sql table and normal pl/sql table
- 2 Answers
- 12951 Views
- I also Faced
- E-Mail Answers
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
what is normalization? : Sql dba
What happens when a trigger is associated to a view?
What are triggers and its types?
Write a query to display the current date in sql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
Why do we need databases?
Which operator is used in query for pattern matching?
What are different types of statements supported by sql?
Can 2 queries be executed simultaneously in a distributed database system?
How many primary keys can a table have?
Which kind of parameters cannot have a default value in pl sql?
What is a design view?
What are tuples in sql?
What is the trigger in sql?
Can variables be used in sql statements?
