type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

What is the difference between sql and isql*plus?

0 Answers  

---

What is pl/sql tables?

7 Answers   TCS,

---

What is rule base and cost base optimizer?

2 Answers   Thermotech,

---

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

2 Answers   Maruti Suzuki,

---

What are expressions?

0 Answers  

---

What is Referential Integrity?

3 Answers  

---

What is sql*loader?

0 Answers  

---

What does pl sql developer do?

0 Answers  

---

what is the use of HASH, LIST partitions?

1 Answers   ITC Infotech,

---

What does data normalization mean?

0 Answers  

---

What is dcl in sql?

0 Answers  

---