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 you write a complex sql query?

1077

---

What is rollback?

1115

---

What is serial sql?

974

---

When should I use nosql database?

1006

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1208

---

What is a natural join?

1071

---

how to select first 5 records from a table? : Sql dba

977

---

What is normalization? How many normalization forms are there?

1085

---

What is an invalid partition table?

1025

---

Is t sql a programming language?

1065

---

How do I get sql certification?

971

---

Which join is like inner join?

1027

---

Is sql a case sensitive language?

945

---

What is the use of function "module procedure" in pl/sql?

1197

---

What is data profiling in sql?

1077

---