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 check server status with 'mysqladmin'? : Sql dba

0 Answers  

---

How do I send sql query results to excel?

0 Answers  

---

How do I delete a trigger?

0 Answers  

---

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---

Can a procedure in a package be overloaded?

0 Answers   EXL,

---

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 Answers  

---

What is the difference between function, procedure and package in pl/sql?

0 Answers  

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

0 Answers  

---

Is sql dba a good career? : SQL DBA

0 Answers  

---

State few characteristics of pl/sql?

0 Answers  

---

What is the limitation on the block size of pl/sql?

0 Answers  

---

how to check myisam tables for errors? : Sql dba

0 Answers  

---