Re: SQL command line unusable in Linux?

From: Burkhard Schultheis <schultheis_at_tde-online.de>
Date: Wed, 22 Mar 2006 10:05:47 +0100
Message-ID: <48cibqFjdc68U1_at_individual.net>


Cris Carampa schrieb:
> Burkhard Schultheis wrote:
>

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

>
> Are you talking about SQL*Plus or a different XE thing? Do the "SET"
> commands apply?

[Quoted] The menu entry is a shell script calling at the end sqplus.sh:

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server export ORACLE_HOME
ORACLE_SID=XE
export ORACLE_SID
NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export NLS_LANG
PATH=$ORACLE_HOME/bin:$PATH
export PATH
sqlplus /nolog

The set command should work because it gives an error message when called without parameters.
Some years ago I worked with SQL*Plus, but I've never seen such a bad output. :-(

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 - 10:05:47 CET

Original text of this message