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;

Does a user_objects view have an entry for a trigger?

0 Answers  

---

How can you create Cursor with parametres ?

3 Answers  

---

what is self-join? : Sql dba

0 Answers  

---

what is the use of friend function? : Sql dba

0 Answers  

---

How do I save a stored procedure?

0 Answers  

---

What do you understand by pl/sql records?

0 Answers  

---

How does sql*loader handles newline characters in a record? : aql loader

0 Answers  

---

Can we insert delete data in view?

0 Answers  

---

How do you copy a table in sql?

0 Answers  

---

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

---

Can procedure in package be overloaded?

0 Answers   EXL,

---

What is the use of prepared statement?

0 Answers  

---