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
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: Oracle
posted by GSharp at
07:57
3 Comments:
Thanks a lot, very clear and concise
By
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, 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, At
8 June 2013 at 12:24
Post a Comment
Subscribe to Post Comments [Atom]
<< Home