Re: how do I concatenate a string in PL/SQL?
- From: David Sharples <davidsharples@xxxxxxxxx>
- To: roger_xu@xxxxxxxxxxx
- Date: Wed, 8 Feb 2006 22:59:09 +0000
you are blowing the size of the variable - use varchar2 instead as your
string is being padded with spaces
On 2/8/06, Roger Xu <roger_xu@xxxxxxxxxxx> wrote:
>
> SQL> !cat /tmp/abc.sql
> set serveroutput on
> set verify off
>
> declare
>
> a_strng CHAR(50);
> a_ATWRT CHAR(30);
>
> begin
>
> a_ATWRT := 'World';
> a_strng := 'Hello';
> a_strng := a_ATWRT || a_strng;
> dbms_output.put_line ( a_strng);
>
> end;
>
> /
Other related posts:
