Answer Posted / mohan

Cursor: Cursor is a pointer which is used to fetch one by one record from active set into plsql block.

Types: There are two types of cursors we have in plsql.
they are,
1. Implicit Cursors
2. Explicit cursors

1.Implicit cursors: when ever we perform sql operations then automatically implicit cursors will come into the picture. no need to declare,open,fetch and close implicit cursors.

2.Explicit cursors: These are user defined cursors. we have to declare,open,fetch and close these cursors.

Cursor Attributes:
1.%found
2.%notfound
3.%isopen
4.%rowcount

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2465

---

please explain.. DB architecture ...

2018

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

1749

---

What are the types of partitions in oracle?

1036

---

What is the difference between Delete, Truncate and Drop in Oracle?

1129

---

Why does for update in oracle 8 cause an ora-01002 error?

1000

---

What is oracle used for?

1022

---

What are the extensions used by oracle reports?

1033

---

Why packages are used in oracle?

1066

---

What are the database administrators utilities available?

1027

---

Is there any function in oracle similar like group_concat of mysql?

1049

---

What is the implicit cursor in oracle?

1102

---

Where do you use decode and case statements?

988

---

How to define a data field as not null?

1105

---

Respected sir, Please send me technical questions related to oracle apps..

1811

---