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;

Is a table valued function object?

1018

---

Can we call a function containing dml statements in a select query?

979

---

What are joins in sql?

1044

---

Define commit, rollback and savepoint?

1027

---

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1068

---

How do I make my sql query run faster?

941

---

What is sql trigger example?

1061

---

what is oracle database ? : Sql dba

1028

---

how to enter numeric values as hex numbers? : Sql dba

1064

---

What is a recursive join sql?

1072

---

How do I run a sql trace?

958

---

What are basic techniques of indexing?

1384

---

What is set serveroutput on?

1136

---

what is a view? : Sql dba

1092

---

How do I save a stored procedure?

1008

---