Answer Posted / shailendra chauhan

For the strong ref cursor the returning columns with
datatype and length need to be known at compile time.

For the weak ref cursor the structure does not need to be
known at compile time.

TYPE WEAK_REF_CURSOR IS REF CURSOR;

TYPE STRONG-_ REF_CURSOR IS REF CURSOR RETURN
TABLE_NAME%ROWTYPE;

What are the different types of dbmss?

563

---

Explain isolation levels. : Transact sql

579

---

How do you take the union of two tables in sql?

516

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1561

---

How do I run sql profiler?

588

---

---

What is auto increment in sql?

588

---

What is a behavioral trigger?

517

---

what are all different types of collation sensitivity? : Sql dba

525

---

Can we use delete in merge statement?

515

---

Show code of a cursor for loop.

584

---

What is the meaning of disabling a trigger?

647

---

what is primary key? : Sql dba

512

---

What are the advantages of pl sql over sql?

548

---

Why is %isopen always false for an implicit cursor?

569

---

Why do we go for stored procedures?

516

---