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,

---

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

0 Answers  

---

What is pl sql block structure?

0 Answers  

---

can we call a procedure from a function?

9 Answers   Mind Tree,

---

What version is sql?

0 Answers  

---

---

how do you count the duplicate records in a table

10 Answers   Tech Mahindra,

---

How can I tell if sql is running?

0 Answers  

---

What is Raise_application_error ?

1 Answers  

---

What is the best partition size for windows 10?

0 Answers  

---

What are the different datatypes available in PL/SQL?

0 Answers  

---

Why commit is not used in triggers?

0 Answers  

---

Explain what is an index?

0 Answers  

---