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 implicit cursor in oracle?

1036

---

Explain how are indexes update?

1014

---

How to display row numbers with the records?

1024

---

How will you write a query to get a 5th rank student from a table student_report?

1813

---

What is archive log in Oracle?

1069

---

Briefly explain what is literal? Give an example where it can be used?

973

---

How to use "in out" parameter properly?

998

---

What is an oracle table?

931

---

Explain self joins in oracle?

949

---

Explain what are the characteristics of data files?

1030

---

How to retrieve data from an cursor to a record?

1012

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1617

---

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

1031

---

What is an oracle cursor variable?

1005

---

How to view the tablespaces in the current database?

927

---