Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Using DESCRIBE command with large LINESIZE set
Saeed wrote:
> The problem I am about to describe afflicts 8i and 8i on Linux, and is
> now showing up in 9i on Windows too. Previous versions of SQL*Plus
> installed on Windows were fine.
>
> If you have Oracle 9i client installed on Windows, you may see this as
> follows:
>
> Logon to SQL*PLus
>
> Type "DESC user_tables"
>
> and you get the usual 3 column output.
>
> Now type "SET linesize 300"
>
> and then "DESC user_tables"
>
> and all you will see is the "name" col, and everything else right over
> to the right hand side, usually hidden as scrolling right doesn't work.
>
> In Linux the telnet emulator causes the output to be wrapped, so you see
> everything, but it's not very clear.
>
> This is obviously annoying, especially if like me you try not to become
> reliant on things like TOAD. It's as though are trying their best to
> stop people using good old SQL*Plus.
>
> Anyone got any ideas of settings that might help?
>
>
> Kind regards,
>
> Saeed
>
> sr_ng 786
There is nothing you can do except reset the linesize.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Thu Mar 18 2004 - 11:34:27 CST
![]() |
![]() |