difference between pl/sql table and normal pl/sql table
Answers were Sorted based on User's Feedback
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 |
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 |
What is referential integrity ?
Does db2 use sql?
What are the uses of merge?
Show the cursor attributes of pl/sql.
How do I turn a list into a table?
What is a unique key and primary key and foreign key?
Why are indexes and views important to an organization?
How do you update a table in sql?
What is the difference between partitioning and sharding?
How can you view the errors encountered in a trigger?
what is column? : Sql dba
What are the types of dbms?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)