Hi Dan,
thanks, but I ment the output size in SQL*Plus when I concatenate the
columns
like:
SELECT RPAD(COL_A_TEXT, 100)||LPAD(TO_CHAR(COL_B_NUM),10)||...
FROM Table_X;
Regards
Reinhard
For direct reply please remove _nospam from address
"DA Morgan" <damorgan_at_exesolutions.com> schrieb im Newsbeitrag
news:3E00ADEA.170C099F_at_exesolutions.com...
> Reinhard wrote:
>
> > Hi there,
> >
> > I tried to select a table by concatenation of the fields with fixed
record
> > length via SQL*Plus
> > and I got the the ORA-01489 error.
> >
> > What's the maximum size of a concatenated string?
> > Can I change SQL*Plus settings to succeed?
> >
> > Thanks in advance
> > --
> > Reinhard
> > --------------------------------------------------------------
> > For direct reply please remove _nospam from address
>
> Depends on your version which you don't mention.
>
> Currently VARCHAR2 is 4K in tables and 32K in variables.
>
> Dan Morgan
> http://www.extension.washington.edu/extinfo/certprog/oad/oad_main.asp
>
Received on Thu Dec 19 2002 - 01:42:55 CST