could you please explain implicit and explicit cursor for interview purpose

Posted on 2012-09-10
Last Modified: 2012-09-10
could you please explain implicit and explicit cursor for interview purpose
Question by:stmani2005
    LVL 34

    Expert Comment

    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.
    LVL 34

    Expert Comment

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

    select count(1)
    into cnt
    from my_table;
    LVL 20

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    Via a live example, show how to take different types of Oracle backups using RMAN.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now