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.

Answer / heena

pl/sql tables are not store in database but normal pl/sql
tables are stored in database

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

---

Do foreign keys improve performance?

0 Answers  

---

What are the modes of parameters that can be passed to a procedure ?

3 Answers  

---

How do you copy a table in sql?

0 Answers  

---

what is constraining table?

2 Answers  

---

---

How many triggers can be implemented for a table?

3 Answers   HSBC,

---

What is the unique index?

0 Answers  

---

what does the t-sql command ident_current does? : Transact sql

0 Answers  

---

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

1 Answers   CTS,

---

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 Answers   Zensar,

---

How many triggers can be applied on a table?

0 Answers  

---

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

---