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@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?

Received on Wed Mar 22 2006 - 02:34:01 CST