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 does sql developer connect to oracle database?

0 Answers  

---

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,

---

What are the different operators available in sql?

0 Answers  

---

how to create a database in oracle?

3 Answers  

---

what is autonomouse transaction?

3 Answers   Oracle,

---

---

What is difference between rank () row_number () and dense_rank () in sql?

0 Answers  

---

what does the t-sql command ident_current does? : Transact sql

0 Answers  

---

What is pl sql collection?

0 Answers  

---

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 Answers  

---

how to saw triggers output in pl/sql database?

1 Answers  

---

What is nosql vs sql?

0 Answers  

---

What is java sql package?

0 Answers  

---