Re: newbie sqlplus ques: big tables crunched in sql window

Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie sqlplus ques: big tables crunched in sql window - hard to read

From: <jonathansamuel_at_my-deja.com>
Date: Fri, 10 Dec 1999 17:48:46 GMT
Message-ID: <82reds$7sk$1@nnrp1.deja.com>

In article <82i4la$ig6$1_at_autumn.news.rcn.net>, "Lee Gold" <leegold_at_erols-nospam-.com> wrote:

> is there a way to tell sql+ to fomat it, maybe not to
wrap, ...anything
> to view the table better (besides using oracle navigator),
>
> how is this usally done/handled??

If you are using the most recent version of SQL*Plus (8.1.5) then from the menu select OPTIONS-->ENVIRONMENT-->WRAP-->CUSTOM-->OFF and OPTIONS- ->ENVIRONMENT-->LINESIZE-->CUSTOM-->1000. This will turn off wrap and truncation for all tables less than 1000 characters wide. If you think your lines will be more than 1000 characters wide then select a larger number.

--Jonathan

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 10 1999 - 11:48:46 CST