Re: Append VARCHAR to LONG data type in PL/SQL

dansanders_at_att.net (Dan) wrote in news:a7f21d41.0304090921.177fc7f6 _at_posting.google.com:

> I am trying to find a way to append a string to the end of a LONG data
> type in pl/sql.
>
> Any suggestions?
>

SQL> create table t (l long);

Table created.

SQL> insert into t values ('like');

1 row created.

SQL> declare

  2     l_lng long;
  3     l_str varchar2(10) := 'this';
  4  begin
  5     select l into l_lng from t;
  6     l_lng := l_lng || ' ' || l_str || '?';
  7     update t set l = l_lng;

PL/SQL procedure successfully completed.

SQL> select * from t;

L

Just in case you can't stop using longs before you need to solve this problem.

Martin Received on Fri Apr 11 2003 - 02:23:48 CEST