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;

How can you save or place your msg in a table?

0 Answers  

---

What is benefit of creating memory optimized table?

0 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT

1 Answers   AOL,

---

What is the requirement of self-join?

0 Answers  

---

How to use transactions efficiently : transact sql

0 Answers  

---

What is the maximum database size for sql express?

0 Answers  

---

diff b/w function and procedure?

9 Answers   iFlex,

---

what is switch column,colums cost in oracle?

0 Answers   Metric Stream,

---

How do I pipe the output of one isql to another?

0 Answers  

---

how to check the 3rd max salary from an employee table?

23 Answers   IBM,

---

How do you optimize a stored procedure in sql?

0 Answers  

---