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 to select unique records from a table? : Sql dba

0 Answers  

---

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers   Keane India Ltd,

---

How bulk collect improves performance?

0 Answers  

---

What are the topics in pl sql?

0 Answers  

---

Can a composite key be null?

0 Answers  

---

---

How will you select unique values from a list of records?

7 Answers   Cap Gemini,

---

what is bcp? When is it used?

0 Answers  

---

What are the disadvantages of file system?

0 Answers  

---

How many types of relationship are there?

0 Answers  

---

How do I save a stored procedure?

0 Answers  

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  

---

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  

---