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;

What is sql and also describe types of sql statements?

993

---

What are few of the schema objects that are created using PL/SQL?

965

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1034

---

what is 'mysqladmin' in mysql? : Sql dba

971

---

Is null operator in sql?

975

---

What is the importance of sqlcode and sqlerrm?

1274

---

How do you write a subquery?

960

---

Can we insert data into materialized view?

896

---

What is oracle and pl sql?

1075

---

How to select all records from the table?

1066

---

who introduced sql?

947

---

how to add a new column to an existing table in mysql? : Sql dba

1000

---

What is query optimization in sql?

933

---

Which sql statement is used to return only different values?

952

---

What are the possible values that can be stored in a boolean data field?

944

---