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 normalization means?

1011

---

Is join same as left join?

1078

---

What is latest version of sql?

1096

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1047

---

How do I install microsoft sql?

1110

---

What is database sql?

1092

---

What is a trigger in sql?

1229

---

How do you clear the screen in sql?

1121

---

What are tuples in sql?

1187

---

What are the types of sql commands?

1151

---

what is 'mysqlshow'? : Sql dba

1069

---

Do we need to create index on primary key?

963

---

Is drop table faster than truncate?

1045

---

how to dump a table to a file with 'mysqldump'? : Sql dba

1094

---

Mention what is the plv (pl/vision) package offers?

1163

---