Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: the output length is just 50 characters
set long 20000 or other value in SQL*Plus
May wrote:
> when i execute
> select sql_text from v$sqltext_with_newlines
> the output's max length is just 50 characters, although i spool it
> into a file is also.
>
> how?
Received on Sat Sep 08 2001 - 13:08:59 CDT