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 user define exception and example
What is loop in pl sql?
In a table only one column how to update rows
Can we join 3 tables in sql?
what are the advantages of package?
How can I speed up sql query?
Can we call stored procedure in function?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
what are all different types of collation sensitivity? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Is not null in sql?
How to call DDL statements from pl/sql?
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)