?
Solved

could you please explain implicit and explicit cursor for interview purpose

Posted on 2012-09-10
3
Medium Priority
?
412 Views
Last Modified: 2012-09-10
could you please explain implicit and explicit cursor for interview purpose
0
Comment
  • 2
3 Comments
 
LVL 35

Expert Comment

by:johnsone
ID: 38383452
The simple answer is an explicit cursor is once you declare and operate on.  And implicit cursor is one that is created behind the scenes for you without you really knowing about it.
0
 
LVL 35

Expert Comment

by:johnsone
ID: 38383526
An example that creates an implicit cursor would be something like this in PL/SQL:


select count(1)
into cnt
from my_table;
0
 
LVL 21

Accepted Solution

by:
Amitkumar P earned 2000 total points
ID: 38383538
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question