long||varchar

[pipo]

note that you can also use a long variable :


declare
var long;
begin
select long_column
into var
from table
where ...;
dbms_output.put_line(var || ' concatened with text');
end;