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
What is difference between mysql and postgresql?
How exception is different from error?
what is schema? : Sql dba
Explain the difference between drop and truncate commands in sql?
What is minus?
What is function and procedure?
Where is all the data on the internet stored?
Is primary key clustered or nonclustered?
What does bitemporal mean?
Why do we use %rowtype & %type in plsql?
Can we join two tables without common column?
Is sql dba a good career? : SQL DBA
How do you use join?
What is percent sign in sql?
Why partition by is used in sql?