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 analyze command used for?

1072

---

What happens to indexes if you drop a table?

1169

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1110

---

How to speed up webrick?

1076

---

How do I connect to oracle database?

1119

---

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1114

---

what is the difference between data migration and production migration.

2346

---

Is oracle the best database?

963

---

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

2969

---

What is query image?

981

---

What is an anonymous block?

1249

---

How will you identify oracle database software release?

1010

---

How to connect asp pages to oracle servers?

1072

---

How to execute the package in oracle?

1082

---

What is oracle server autotrace in oracle?

1166

---