Answer Posted / joseph p v

2 Types
-Implicit Cursor
-Explicit Cursor

-Implicit Cursor
All select queries are examples of implicit cursor. While
submitting a select query , Oracle internally handle the
Open, fetch and close operations. Implicit Cursors are
using while query returns only row.

-Explicit Cursor
We want to explicitly define one cursor, open the cursor,
fetch and close the same. These type cursors are using
while the query return more than one row.

Ref Cursors are Cursors having the dynamic cursor statement
capabilities.

How do I view output in sql developer?

1116

---

Is primary key clustered index?

990

---

What is clustered index sql?

1024

---

What are the types of triggers in sql?

1140

---

Why is sharding used?

1056

---

What are the types of join and explain each?

1097

---

What is t-sql? : Transact sql

1035

---

what is the difference between cluster and non cluster index? : Sql dba

1071

---

What are different types of sql?

1255

---

How does cross join work?

1004

---

How do I view stored procedures?

1020

---

How to check if a column is nullable before setting to nullable?

1173

---

How does postgresql compare to mysql?

1075

---

Which join condition can be specified using on clause?

1008

---

what is self-join? : Sql dba

1232

---