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

What is a table in a database?

1041

---

What is sql table?

959

---

What is pl sql architecture?

953

---

What is the purpose of primary key?

1012

---

What are the benefits of pl sql?

1110

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4014

---

Why is sql important?

1095

---

What are the possible values for the boolean data field?

952

---

How many types of sql are there?

983

---

Can a trigger call a stored procedure?

1060

---

Why do we use %rowtype & %type in plsql?

1041

---

Is left join same as inner join?

1108

---

How many postgresql users are there, worldwide?

1054

---

What is a design view?

920

---

What sql database should I use?

1131

---