difference between pl/sql table and normal pl/sql table
- 2 Answers
- 12313 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
Explain the methods used to protect source code of pl/sql.
Explain the types of joins in sql?
What is sql dialect?
What is an invalid partition table?
What is an implicit commit?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What is mdb stand for?
What is pl sql in oracle?
what is dbms? : Sql dba
how is exception handling handled in mysql? : Sql dba
What is cursor in pl sql?
What is the cause of mutating table error and how can we solve it?
What are sql functions? Describe in brief different types of sql functions?
What is group function in sql?
Differentiate pl/sql and sql?
