Answer / slokh

when we fire any DML operation a memory is alocated. this
memory area is called context area or cursor. data is
retieved and stored in this area

implicit cursors are automatically created by the Oracle.
when you perform any DML operation a memory has been
automatically created, and when the operation is finished
it automatically release the memory space, here every thing
is controlled by the oracle itself.

explicit cursors are the cursors, where the user defined
for which select statement the cursor is being created,
when to fetch the data, and release the memory space. on
other words the control is over the programmer.

Answer / gaurav gupta

However,queries that return more than one row you must
declare an explicit cursor or use a cursor FOR loop.
Explicit cursor is a cursor in which the cursor name is
explicitly assigned to a SELECT statement via the
CURSOR...IS statement.

An implicit cursor is used for all SQL statements Declare,
Open, Fetch, Close. An explicit cursors are used to process
multirow SELECT statements An implicit cursor is used to
process INSERT, UPDATE, DELETE and single row SELECT. .INTO
statements.

How to call the function and Procedure in trigger?

3 Answers   IBM,

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

0 Answers  

---

Can we have two clustered index on a table?

0 Answers  

---

Can a varchar be a primary key?

0 Answers  

---

What problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

How to run sql commands in sql*plus?

0 Answers  

---

How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

10 Answers   Mind Tree, Polaris, Sonata,

---

What is the use of triggers?

0 Answers  

---

Is merge a dml statement?

0 Answers  

---

how to get @@error and @@rowcount at the same time? : Sql dba

0 Answers  

---

Can you have more than one trigger on a table?

0 Answers  

---

Can we change the table name in sql?

0 Answers  

---