Re: SQL plus help for Newbie
Date: Mon, 23 Apr 2001 23:38:17 -0500
Message-ID: <0r7F6.1784$fj1.546788_at_news.uswest.net>
The ORA-00900 tells you that Oracle is in fact trying to execute your SQL*Plus COLUMN command ... on the server ... which is a bad thing. SQL*Plus commands must be executed by SQL*Plus itself. The most common cause of this for new folks is that the SQL*Plus command gets put into the SQL buffer. Make sure you are using START or _at_ to run the script, not GET or CUT/PASTE, etc., which would put the COLUMN command into the SQL buffer and send it on its way to the Oracle server.
Hope this helps,
Chris
Chris Leonard
MCSE, MCDBA, MCT, OCP, CIW
The Database Guy at PPI
http://www.propoint.com
Brainbench MVP for Oracle Admin
http://www.brainbench.com
"Eric from Speco" <eric_at_speco.com> wrote in message
news:9c22qc$8a5$1_at_bob.news.rcn.net...
> I can't seem to get the column command or Break command to work on my work
> machine
> When I run a similar command at school with the same syntax all's OK.
>
> Is there something in the installation that could have caused my problem?
> Am I correct in assuming that column and break commands are executed on
the
> client and only a parsed statement is passed to the server
>
> Here's examples of 2 similar scripts. One works the other doesn't.
>
> This script runs fine
>
> 1 SELECT DISTINCT items.t$item "Raw Item", items.t$dsca, bom.t$mitm,
> sub.t$dsca
> 2 FROM baan.ttiitm001100 items, baan.ttibom010100 bom,
> 3 (SELECT ttibom010100.t$mitm, ttiitm001100.t$dsca
> 4 FROM baan.ttibom010100, baan.ttiitm001100
> 5 WHERE ttibom010100.t$mitm = ttiitm001100.t$item) sub
> 6 WHERE bom.t$sitm = items.t$item
> 7 AND bom.t$mitm = sub.t$mitm
> 8* AND (Items.t$item = '108157')
> 9
> SQL> /
>
> But this one doesn't
> 1 COLUMN items.t$item HEADING "Raw Item"
> 2 SELECT DISTINCT items.t$item, items.t$dsca, bom.t$mitm, sub.t$dsca
> 3 FROM baan.ttiitm001100 items, baan.ttibom010100 bom,
> 4 (SELECT ttibom010100.t$mitm, ttiitm001100.t$dsca
> 5 FROM baan.ttibom010100, baan.ttiitm001100
> 6 WHERE ttibom010100.t$mitm = ttiitm001100.t$item) sub
> 7 WHERE bom.t$sitm = items.t$item
> 8 AND bom.t$mitm = sub.t$mitm
> 9* AND (Items.t$item = '108157')
> 10
> SQL> /
> COLUMN items.t$item HEADING "Raw Item"
> *
> ERROR at line 1:
> ORA-00900: invalid SQL statement
>
>
> FYI Version info is
> Disconnected from Oracle7 Server Release 7.3.4.0.1 - Production
> PL/SQL Release 2.3.4.0.0 - Production
>
>
> Thanx in advance
> Eric
>
>
Received on Tue Apr 24 2001 - 06:38:17 CEST