Answer Posted / avi007

cursor-
1 cursor is small memory area to perform selection on the
one or more table.
2 cursor is a variable which is 2 dimentional array, it is
handling, storing and processin multiple rows.
3 storing data temporarily.
4 fetching rows from top to bottom.
5 fetching row one at a time.

procedure -
1 procedure is an object of database.
2 need to compile and execute.
3 dml operation performed in the block.

How does join work in sql?

549

---

What is the use of non clustered index?

526

---

What do you mean by rowid?

535

---

How can we solve sql error: ora-00904: invalid identifier?

695

---

Can dml statements be used in pl/sql?

570

---

---

What is oracle sql called?

502

---

Why having clause is used in sql?

533

---

Why do we use triggers?

511

---

What is sqlerrm?

541

---

Explain scalar functions in sql?

575

---

What is indexing oracle sql?

556

---

What is difference between cursor and trigger?

551

---

What are different types of sql?

555

---

What is $$ in sql?

547

---

What is the difference between the implicit and explicit cursors?

521

---