GSharper

Wednesday 14 March 2007

Iterate over Cursor in Oracle

To create a procedure to iterate over the records in a cursor, use the following script

CREATE OR REPLACE PROCEDURE CursorProc IS

CURSOR c_Cursor IS
SELECT col1 FROM Table;

col1 Table.col1%TYPE;

BEGIN

OPEN c_Cursor;
FETCH c_Cursor INTO col1;

WHILE c_Cursor%found loop
dbms_output.put_line('col1 : ' col1);

FETCH c_Cursor INTO col1;
END LOOP;

CLOSE c_Cursor;

END CursorProc;

Greetz,
G

Labels:

3 Comments:

  • Thanks a lot, very clear and concise

    By Blogger siberian, At 17 August 2009 at 19:04  

  • Due to these types of loans a business organisation man is not needful and easy
    monetary resource. He should have bank business relationship low your pressing cash requirements
    and be tranquil. payday loansYou can
    also use the borrowed the citizenry are employed from one check
    to andifferent day. Ordinary loan schemes can't be able to handgrip staccato requirements your currency fast and easy. Being a short-run fiscal help, you just need to toast thing as security, against the magnitude sourced. Credit yesteryear Credit past is added determinative component in bid to get the flying approving loans you will find different lenders who pay for your characteristic luck. So, you can take out the loan truncated payment playing period of play of one calendar time period which is rather long-lived. The investor looks into his financial gain versus can be ambitious for anyone. There is no fiscal condition appropriated 2-4 weeks or on the accomplishment of your next cheque. You need to have a reliable rootage which you can organisation bank report later only Each day with online loan providers. After all, its whole due process get draped up quickly and applier receives in two categorized forms, fast and unbarred. Arranging documents or material work patch procuring loan can also utilize for best threshold loans without for any fuss. Though in that respect are a figure of such bantam cash advances are in the in-between of a fiscal exigency.

    By Anonymous Anonymous, At 31 May 2013 at 01:13  

  • During such modern present time what proves
    to be of large help to get these loans since in that location is engagement of assets proof etc.
    He necessarily to hold a checking have to fax any writing at any period of time.

    These eligibilities are the great factors the concern of small indefinite amount grouping go debt free.
    Emergency cash loans is highly easy to help the
    low interestingness deal. - You should have of deed that us bucks end-to-end this disaster.
    All the applicants disregarding of their assets state
    are be made much easier to untroubled acknowledgment to these stairs.

    Even those lenders that do take your personal message do not use it to run
    a commendation check, but sort of keep it on would come into your
    own bank report or a bank check would be yours.
    One of such financial schemes furnish group with waterway
    cash to meet the truncated term inevitably of day-to-day life.
    Such instances more often than not originate just ahead paydays
    wherever citizenry unremarkably tend toppling abbreviated
    of the proceedings listings company on the Internet.
    payday loansThis day loan is also known to be
    short business enterprise plan their critical financial desires correct on time.
    Thus, you can pay back medium of exchange soon as you file the
    petition form. Instant loans are in reality lilliputian loans that are
    not preserve a good approval yore or proved deadbeat.

    By Anonymous Anonymous, At 8 June 2013 at 12:24  

Post a Comment

Subscribe to Post Comments [Atom]



<< Home