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;

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

---

PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  

---

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?

7 Answers   PreVator,

---

please explain database architecture..

1 Answers   Infosys,

---

What is date functions?

0 Answers  

---

Is sql database free?

0 Answers  

---

Is left join inner or outer?

0 Answers  

---

How to prepare for oracle pl sql certification?

0 Answers  

---

How does a covering index work?

0 Answers  

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

What is memory optimized?

0 Answers  

---

Is a view faster than a stored procedure?

0 Answers  

---