Answer Posted / prabu t

Varray -
Can be stored in the database.
Bounded (maximum length should be given).
Delete / Remove values only from the end.

Nested Tables -
Cannot be strored in the database.
Unbounded (No maximum length).
Delete / Remove values anywhere in the table.

how many triggers are allowed in mysql table? : Sql dba

761

---

what is the different between now() and current_date()? : Sql dba

703

---

Does truncate remove indexes?

721

---

define sql delete statement ? : Sql dba

745

---

What is trigger in sql?

784

---

---

Which software is used for pl sql programming?

680

---

What is raw datatype in sql?

725

---

How do you modify a column in sql?

730

---

Are sql database names case sensitive?

687

---

What is #table in sql?

706

---

how to convert character strings to numeric values? : Sql dba

771

---

What is sequence in sql?

720

---

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

729

---

what is single byte over head in oracle..?

2090

---

define sql insert statement ? : Sql dba

750

---