Answer Posted / suresh kumar somayajula

Re-usability of a cursor is nothing but " REF CURSOR".
It is of 2 types.
1. Weak REF Cursor
2. Strong REF Cursor.

SYNTAX:
1.Strong Refcursor
SYN: TYPE <TYPE_NAME> IS
REFCURSOR RETURN <RETURN_DATA_TYPE>
2.Weak Refcursor
SYN : TYPE <TYPE_NAME> IS
REFCURSOR

Thank you,
Suresh

How to execute a stored procedure?

1148

---

How do you know if a relationship is 2nf?

989

---

What is coalesce in sql?

1127

---

What is sql used for?

1158

---

What are keys in sql?

1036

---

What is function and procedure?

1072

---

Are views faster than queries?

1034

---

Why do we need pl sql?

1031

---

Is sqlite good enough for production?

1036

---

What is the largest value that can be stored in a byte data field?

1054

---

What sql does db2 use?

1023

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1620

---

What jobs use sql?

1029

---

What is the difference between sql and isql*plus?

1154

---

What is sap sql?

1024

---