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

Name the different types of indexes in sql and define them.

1074

---

give the syntax of grant and revoke commands? : Sql dba

1088

---

How to take user input in pl sql?

1106

---

describe transaction-safe table types in mysql : sql dba

944

---

how can you create an empty table from an existing table? : Sql dba

1077

---

What are the types of views in sql?

1039

---

What is sql entity?

1030

---

Are null values same as that of zero or a blank space?

967

---

What does count (*) do in sql?

952

---

What is %type in sql?

917

---

What is a primary key called that is made up of more than one field?

1282

---

What is AUTH_ID and AUTH_USER in pl/sql ?

2137

---

What is crud sql?

921

---

what is the difference between join and union? : Sql dba

1028

---

when MSQL8.0 is in market

2014

---