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 will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  

---

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

---

How many triggers can be implemented for a table?

3 Answers   HSBC,

---

how to convert character strings to dates? : Sql dba

0 Answers  

---

---

What type of join is sql join?

0 Answers  

---

What is dialect in sql?

0 Answers  

---

What are sql queries used for?

0 Answers  

---

What is %type in sql?

0 Answers  

---

What is exit statement?

0 Answers  

---

Why do we need cursor in pl sql?

0 Answers  

---

what is purge command explain about oracle performance tuning

2 Answers   Accenture, eCentric Solutions,

---