SQL command line unusable in Linux?
From: Burkhard Schultheis <schultheis_at_tde-online.de>
Date: Wed, 22 Mar 2006 09:34:01 +0100
Message-ID: <48cggbFjgm8pU1_at_individual.net>
[Quoted] [Quoted] I'm trying Oracle XE on Linux (SuSE 9.3). There is a menu entry for the [Quoted] SQL command line. But it is nearly unusable: The output from command 'select * from <table name> is unreadable:
ZEITSTEMPEL_GEKOMMEN
ZEITSTEMPEL_GEGANGEN
ZEITSTEMPEL_GEKOMMEN
ZEITSTEMPEL_GEGANGEN
--------------------------------------------------------------------------------21.03.06
15:11:08,338065
ZEITSTEMPEL_GEKOMMEN
ZEITSTEMPEL_GEGANGEN
ZEITSTEMPEL_GEKOMMEN
ZEITSTEMPEL_GEGANGEN
--------------------------------------------------------------------------------Text1
ZEITSTEMPEL_GEKOMMEN
ZEITSTEMPEL_GEGANGEN
ZEITSTEMPEL_GEKOMMEN
ZEITSTEMPEL_GEGANGEN
ZEITSTEMPEL_GEKOMMEN
ZEITSTEMPEL_GEGANGEN
ZEITSTEMPEL_GEKOMMEN
ZEITSTEMPEL_GEGANGEN
Date: Wed, 22 Mar 2006 09:34:01 +0100
Message-ID: <48cggbFjgm8pU1_at_individual.net>
[Quoted] [Quoted] I'm trying Oracle XE on Linux (SuSE 9.3). There is a menu entry for the [Quoted] 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 TEXT2KOMMENTAR
------------------------------ ------------------------------
TEXT3 TEXT4
------------------------------ ------------------------------
TEXT5 ZUSTAND URSACHE
------------------------------ ------------------------------ ----------
1
ID
ZEITSTEMPEL_GEKOMMEN
ZEITSTEMPEL_GEGANGEN
TEXT1 TEXT2KOMMENTAR
------------------------------ ------------------------------
TEXT3 TEXT4
------------------------------ ------------------------------
TEXT5 ZUSTAND URSACHE
------------------------------ ------------------------------ ----------
--------------------------------------------------------------------------------21.03.06
15:11:08,338065
ID
ZEITSTEMPEL_GEKOMMEN
ZEITSTEMPEL_GEGANGEN
TEXT1 TEXT2KOMMENTAR
------------------------------ ------------------------------
TEXT3 TEXT4
------------------------------ ------------------------------
TEXT5 ZUSTAND URSACHE
------------------------------ ------------------------------ ----------
ID
ZEITSTEMPEL_GEKOMMEN
ZEITSTEMPEL_GEGANGEN
TEXT1 TEXT2KOMMENTAR
------------------------------ ------------------------------
TEXT3 TEXT4
------------------------------ ------------------------------
TEXT5 ZUSTAND URSACHE
------------------------------ ------------------------------ ----------
--------------------------------------------------------------------------------Text1
ID
ZEITSTEMPEL_GEKOMMEN
ZEITSTEMPEL_GEGANGEN
TEXT1 TEXT2KOMMENTAR
------------------------------ ------------------------------
TEXT3 TEXT4
------------------------------ ------------------------------
TEXT5 ZUSTAND URSACHE
------------------------------ ------------------------------ ----------
ID
ZEITSTEMPEL_GEKOMMEN
ZEITSTEMPEL_GEGANGEN
TEXT1 TEXT2KOMMENTAR
------------------------------ ------------------------------
TEXT3 TEXT4
------------------------------ ------------------------------
TEXT5 ZUSTAND URSACHE
------------------------------ ------------------------------ ----------
[Quoted] Alarm 1 ID
ZEITSTEMPEL_GEKOMMEN
ZEITSTEMPEL_GEGANGEN
TEXT1 TEXT2KOMMENTAR
------------------------------ ------------------------------
TEXT3 TEXT4
------------------------------ ------------------------------
TEXT5 ZUSTAND URSACHE
------------------------------ ------------------------------ ----------
ID
ZEITSTEMPEL_GEKOMMEN
ZEITSTEMPEL_GEGANGEN
TEXT1 TEXT2KOMMENTAR
------------------------------ ------------------------------
TEXT3 TEXT4
------------------------------ ------------------------------
TEXT5 ZUSTAND URSACHE
------------------------------ ------------------------------ ----------
SQL> [Quoted] It should show only 1 line, but it shows the header lines 8 times! How [Quoted] 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?Received on Wed Mar 22 2006 - 09:34:01 CET