how do I concatenate a string in PL/SQL?

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Wed, 8 Feb 2006 15:11:59 -0600
Message-ID: <A6801E8A03316A4DA597866F77A013F7095E6858@irv2kexch01.tx.bg.corp>

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_at_dp7uptx.com.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 08 2006 - 15:11:59 CST