Answer Posted / faize

when query is executed in oracle then result set is
produced & stored in the memory.Oracle allows the
programmer to access this resultset in the memory through
cursors
two types of cursors:
1.Explict cursor
2.Implict cursor

How to assign data of the deleted row to variables?

1116

---

What is an oracle table?

1032

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2234

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1134

---

How to invoke the data pump export utility?

1252

---

What is a read write transaction in oracle?

1132

---

List out the types of joins.

1238

---

How to calculate date and time differences in oracle?

1097

---

What is Reduced List of Values?

2244

---

Can we write dml statement in function in oracle?

1125

---

Can a formula column be obtained through a select statement ?

2380

---

Explain about functional dependency and its relation with table design?

1061

---

How to lock and unlock a user account in oracle?

1161

---

How to change system global area (sga) in oracle?

1066

---

What do you mean by redo log file mirroring?

1069

---