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.

what is timestamp in mysql? : Sql dba

0 Answers  

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

0 Answers  

---

Are pl sql variables case sensitive?

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

---

Which sql statement is used to delete data from a database?

0 Answers  

---

How is use pl and sql?

0 Answers  

---

What is offset and limit in sql?

0 Answers  

---

what are the differences between char and varchar? : Sql dba

0 Answers  

---

What is sql prepared statement?

0 Answers  

---

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

0 Answers  

---

What is sharding in sql?

0 Answers  

---