how do I concatenate a string in PL/SQL?
- From: "Roger Xu" <roger_xu@xxxxxxxxxxx>
- To: "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 8 Feb 2006 15:11:59 -0600
I am a PL/SQL newbie and the following gives me errors while executing.
a_strng := NULL;
open b_cursor;
loop
fetch b_cursor into a_ATWRT;
a_strng := a_ATWRT || a_strng;
exit when b_cursor%NOTFOUND;
end loop;
close b_cursor;
Thanks,
Roger
This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information. Any
review, dissemination, copying, printing or other use of this e-mail by persons
or entities other than the addressee is prohibited. If you have received this
e-mail in error, please contact the sender immediately and delete the material.
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email Security
System. Any questions please call 972-721-8257 or email your request to
tech_support@xxxxxxxxxxxx
Other related posts:
