Answer Posted / anil kumar jaiswal

cursor :

Oracle create a memory area called context area to execute sql statements. that context area keep all information about the statement processed.
cursor is just a pointer to that context area and you can also say a cursor is pointing to result set of a query.
Types cursor :
1.Implicit cursor : implicit cursor automatically created by oracle when ever there is dml operation performed inside pl/sql block.(dml operation means insert,update,delete).
2. Explicit Cursor : its a user defined cursor, user need to define it explicitly.
cursor declared in declaration section called explicit cursor.

Cursor Attributes : there is 4 types of cursor attributes used.
1.%notfound.
2.%found.
3.%isopen
4.%rowcount.
for more queries contact me on aniljaiswal143@gmail.com.

Is nosql relational?

935

---

How do you create a unique index?

1041

---

What do you know by pl/sql cursors?

1095

---

What is dml statement?

945

---

What is rank function in sql?

1012

---

Is mariadb nosql?

1034

---

What does subquery mean in sql?

1044

---

How can I tell if sql is running?

1043

---

Can we join more than 2 tables in sql?

1009

---

How to write a query to show the details of a student from students table whose

990

---

Can we rollback after truncate?

1022

---

what is the difference between clustered and non clustered index in sql? : Sql dba

1115

---

What is on delete restrict?

996

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

960

---

What is data control language?

979

---