Answer / Pradeep Dwivedi

"A cursor in Oracle is a database object that represents a set of rows returned by an SQL query. It allows you to iterate through the rows one at a time, process them, and perform dynamic SQL operations. A cursor can be declared using the DECLARE statement followed by the CURSOR keyword, and opened using the OPEN keyword.

What is a Segment ?

1 Answers  

---

What is oracle host variable?

1 Answers  

---

What is Hash Cluster ?

2 Answers  

---

What is the difference between substr and instr?

1 Answers  

---

Differentiate between TRUNCATE and DELETE?

2 Answers  

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

1 Answers   TCS,

---

Does rowid change in oracle?

1 Answers  

---

How to work with data objects interactively?

1 Answers  

---

What are Clusters ?

5 Answers   Amdocs, Infosys,

---

What is the difference between truncate & delete command?

1 Answers  

---

Difference between inner join vs where ?

1 Answers  

---

What is a subquery in oracle?

1 Answers  

---