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>
>
> Are you talking about SQL*Plus or a different XE thing? Do the "SET"
> commands apply?
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