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;

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

---

Explain the purpose of %type and %rowtype data types with the example?

0 Answers  

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

4 Answers  

---

how to analyze tables with 'mysqlcheck'? : Sql dba

0 Answers  

---

What is the use of index in hive?

0 Answers  

---

What is a string data type in sql?

0 Answers  

---

Types of backups ?

3 Answers   TCS,

---

What is varchar sql?

0 Answers  

---

What is dcl in sql?

0 Answers  

---

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

Is natural join and inner join same?

0 Answers  

---