Interested to Buy Any Domain ? << Click Here >> for more details...
difference between pl/sql table and normal pl/sql table
- 2 Answers
- 13061 Views
- I also Faced
- E-Mail Answers
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 the use of partition by in sql?
What is a loop in sql?
How many types of tables are there?
What is information schema in sql?
How many primary keys can a table have?
What are the 3 types of behavioral triggers?
What is sql rowcount?
Does inner join return duplicate rows?
What is type and rowtype in pl sql?
can sql servers linked to other servers like oracle? : Sql dba
What is difference between inner join and cross join?
Explain the significance of the & and && operators in pl sql.
Why stored procedures are faster than query?
How do we use distinct statement? What is its use?
Is it possible to create startup or shutdown trigger for on-schema?
