Re: SQL command line unusable in Linux?

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Wed, 22 Mar 2006 15:47:38 GMT
Message-ID: <ukeUf.172$%H.171_at_clgrps13>

"Burkhard Schultheis" <schultheis_at_tde-online.de> wrote in message news:48cggbFjgm8pU1_at_individual.net...
> I'm trying Oracle XE on Linux (SuSE 9.3). There is a menu entry for the
> SQL command line. But it is nearly unusable: The output from command
> 'select * from <table name> is unreadable:
>
> SQL> select * from fadis;
>
> ID
> ----------
> ZEITSTEMPEL_GEKOMMEN
> --------------------------------------------------------------------------
-
> ZEITSTEMPEL_GEGANGEN
> --------------------------------------------------------------------------
-
> TEXT1 TEXT2
> ------------------------------ ------------------------------
> TEXT3 TEXT4
> ------------------------------ ------------------------------
> TEXT5 ZUSTAND URSACHE
> ------------------------------ ------------------------------ ----------
> KOMMENTAR
> --------------------------------------------------------------------------

---

> 1
>
> ID
> ----------
> ZEITSTEMPEL_GEKOMMEN
> --------------------------------------------------------------------------
-
> ZEITSTEMPEL_GEGANGEN
> --------------------------------------------------------------------------
-
> TEXT1 TEXT2
> ------------------------------ ------------------------------
> TEXT3 TEXT4
> ------------------------------ ------------------------------
> TEXT5 ZUSTAND URSACHE
> ------------------------------ ------------------------------ ----------
> KOMMENTAR
> --------------------------------------------------------------------------
------21.03.06
> 15:11:08,338065
>
> ID
> ----------
> ZEITSTEMPEL_GEKOMMEN
> --------------------------------------------------------------------------
-
> ZEITSTEMPEL_GEGANGEN
> --------------------------------------------------------------------------
-
> TEXT1 TEXT2
> ------------------------------ ------------------------------
> TEXT3 TEXT4
> ------------------------------ ------------------------------
> TEXT5 ZUSTAND URSACHE
> ------------------------------ ------------------------------ ----------
> KOMMENTAR
> --------------------------------------------------------------------------

---

>
> ID
> ----------
> ZEITSTEMPEL_GEKOMMEN
> --------------------------------------------------------------------------
-
> ZEITSTEMPEL_GEGANGEN
> --------------------------------------------------------------------------
-
> TEXT1 TEXT2
> ------------------------------ ------------------------------
> TEXT3 TEXT4
> ------------------------------ ------------------------------
> TEXT5 ZUSTAND URSACHE
> ------------------------------ ------------------------------ ----------
> KOMMENTAR
> --------------------------------------------------------------------------
------Text1
>
> ID
> ----------
> ZEITSTEMPEL_GEKOMMEN
> --------------------------------------------------------------------------
-
> ZEITSTEMPEL_GEGANGEN
> --------------------------------------------------------------------------
-
> TEXT1 TEXT2
> ------------------------------ ------------------------------
> TEXT3 TEXT4
> ------------------------------ ------------------------------
> TEXT5 ZUSTAND URSACHE
> ------------------------------ ------------------------------ ----------
> KOMMENTAR
> --------------------------------------------------------------------------

---

>
> ID
> ----------
> ZEITSTEMPEL_GEKOMMEN
> --------------------------------------------------------------------------
-
> ZEITSTEMPEL_GEGANGEN
> --------------------------------------------------------------------------
-
> TEXT1 TEXT2
> ------------------------------ ------------------------------
> TEXT3 TEXT4
> ------------------------------ ------------------------------
> TEXT5 ZUSTAND URSACHE
> ------------------------------ ------------------------------ ----------
> KOMMENTAR
> --------------------------------------------------------------------------

---

> Alarm 1
>
> ID
> ----------
> ZEITSTEMPEL_GEKOMMEN
> --------------------------------------------------------------------------
-
> ZEITSTEMPEL_GEGANGEN
> --------------------------------------------------------------------------
-
> TEXT1 TEXT2
> ------------------------------ ------------------------------
> TEXT3 TEXT4
> ------------------------------ ------------------------------
> TEXT5 ZUSTAND URSACHE
> ------------------------------ ------------------------------ ----------
> KOMMENTAR
> --------------------------------------------------------------------------

---

>
> ID
> ----------
> ZEITSTEMPEL_GEKOMMEN
> --------------------------------------------------------------------------
-
> ZEITSTEMPEL_GEGANGEN
> --------------------------------------------------------------------------
-
> TEXT1 TEXT2
> ------------------------------ ------------------------------
> TEXT3 TEXT4
> ------------------------------ ------------------------------
> TEXT5 ZUSTAND URSACHE
> ------------------------------ ------------------------------ ----------
> KOMMENTAR
> --------------------------------------------------------------------------

---

>
> SQL>
>
> It should show only 1 line, but it shows the header lines 8 times! How
> must I configure the SQL*Plus command line?
>
> Regards,
> Burkhard
> --
> A: Weil es die Lesbarkeit des Textes verschlechtert.
> F: Warum ist TOFU so schlimm?
> A: TOFU
> F: Was ist das größte Ärgernis im Usenet?

Check the SQLPlus manual for the SET commands. In this case: set linesize

-- 
Terry Dykstra
Canadian Forest Oil Ltd.

Received on Wed Mar 22 2006 - 16:47:38 CET