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 use of & in pl sql?

0 Answers  

---

Explain the difference between drop and truncate commands in sql?

0 Answers  

---

How can I get the number of records affected by a stored procedure?

0 Answers  

---

what is difference between delete and truncate commands? : Sql dba

0 Answers  

---

---

How is data stored in sql?

0 Answers  

---

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

---

What is the difference between a database and a relational database?

0 Answers  

---

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  

---

Can a select statement fire a trigger?

0 Answers  

---

What is the usage of sql functions?

0 Answers  

---

What is pl sql package?

0 Answers  

---