Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Using DESCRIBE command with large LINESIZE set

Re: Using DESCRIBE command with large LINESIZE set

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 18 Mar 2004 09:34:27 -0800
Message-ID: <1079631243.426021@yasure>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US