Cursor: Cursor is a pointer which is used to fetch one by one record from a

what are the different types of cursors? explain?

Question Posted / mohan

4 Answers
8439 Views
I also Faced
E-Mail Answers

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

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you mean by group by clause?

551

Can the query output be sorted by multiple columns in oracle?

565

What would you do with an in-doubt distributed transaction?

1466

How do I escape a reserved word in oracle?

623

How to convert dates to characters in oracle?

577

How to start your 10g xe server?

585

Can we convert a date to char in oracle and if so, what would be the syntax?

546

What happens to the current transaction if the session is ended?

520

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1477

Can you create a synonym without having a table?

544

Explain the use of control file?

650

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

1954

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1801

What is tns service name?

610

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

4925