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 |
select top 3 sal from each dept?
17 Answers IBM, TCS,
what is a database transaction? : Sql dba
Why plvtab is considered as the easiest way to access the pl/sql table?
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently
Can I learn sql in a week?
Why schema is used in sql?
How can you load multi line records? : aql loader
My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?
how to create a new view in mysql? : Sql dba
What is not in sql?
what is “go” in t-sql? : Transact sql
How to start the command-line sql*plus?
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)