Answer / 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;

full outer join syntax

5 Answers  

---

Why stored procedure is faster than query?

0 Answers  

---

What is the difference between the implicit and explicit cursors?

0 Answers  

---

how can i read write files from pl/sql

3 Answers  

---

What is sql and db2?

0 Answers  

---

---

What is materialized view in sql?

0 Answers  

---

what does the t-sql command ident_incr does? : Transact sql

0 Answers  

---

what are the difference between clustered and a non-clustered index? : Sql dba

0 Answers  

---

How can we avoid duplicating records in a query?

0 Answers  

---

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

---

How to fetch the rows by dynamicaly passing table name through cursor?

3 Answers  

---

How do you take the union of two tables in sql?

0 Answers  

---