Answer Posted / shriram

It is a type of composite data type in pl sql .. The other
two composite types are nested tables and varrays .. example :
TYPE type_name IS TABLE OF NUMBER INDEX BY VARCHAR2(64);
name type_name;

It is also called as index by tables.
Now "name" can be given any values like :

name('raja'):=100;

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

778

---

What is trigger types in sql?

719

---

Can we use ddl statements in stored procedure sql server?

721

---

what is a composite key ? : Sql dba

798

---

What is java sql drivermanager?

746

---

---

Why is there a need for sqlcode and sqlerrm variables?

756

---

What is the difference between microsoft access and sql server?

713

---

Can we use view in stored procedure?

700

---

What programs use sql?

729

---

What is the difference between local variables and global variables?

800

---

What is #table in sql?

706

---

what is transaction? : Sql dba

719

---

What is coalesce in sql?

732

---

How to rename a table?

766

---

How can we avoid duplicating records in a query?

739

---