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 i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

---

What is difference between mysql and postgresql?

0 Answers  

---

How to access the current value and next value from a sequence?

6 Answers  

---

What is trigger explain with example?

0 Answers  

---

real time applications of nullif?

3 Answers  

---

What does an inner join do?

0 Answers  

---

What is the difference between sql/pl-sql/embeded sql?

3 Answers  

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

Give an example of any procedure.

5 Answers   Accenture, iFlex, Wipro,

---

which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

---

Can variables be used in sql statements?

0 Answers  

---

What is denormalization in a database?

0 Answers  

---