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
How do you declare a variable in pl sql?
How to Declare Fixed Length String Value In PL SQL
How to take user input in pl sql?
How do you delete a table?
what are the different functions in sorting an array? : Sql dba
Define union, minus, union all, intersect ?
How would you convert date into julian date format?
Is mariadb a nosql database?
Is trigger a stored procedure?
How do you concatenate in sql?
What are the uses of merge?
Can we join 3 tables in sql?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
How do I sort a table in sql?
What is sql indexing?