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.

Why join is faster than subquery?

1095

---

Is null operator in sql?

1016

---

What is count * in sql?

985

---

what is index? : Sql dba

991

---

How does a self join work?

1083

---

What is rtm stands for?

1080

---

What is query execution plan in sql?

1174

---

What view means?

965

---

what is cross join? : Sql dba

981

---

When is the update_statistics command used?

1093

---

Can you upgrade sql express to full sql?

1046

---

How to make a copy values from one column to another in sql?

1026

---

What is localdb mssqllocaldb?

1057

---

Why we use join in sql?

946

---

What is sql engine in oracle?

974

---