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 the conventional and direct path loads? : aql loader

0 Answers  

---

What is sql clause?

0 Answers  

---

Do foreign keys improve performance?

0 Answers  

---

How many types of relationship are there?

0 Answers  

---

---

What is the default value of CHAR type?

3 Answers   Bosch,

---

What is a composite primary key?

0 Answers  

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

0 Answers  

---

What does count (*) do in sql?

0 Answers  

---

real time applications of nullif?

3 Answers  

---

Talk about views

10 Answers   Polaris,

---

explain about mysql and its features. : Sql dba

0 Answers  

---