SQL plus help for Newbie
Date: Mon, 23 Apr 2001 15:20:41 -0500
Message-ID: <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
Is there something in the installation that could have caused my problem?
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
When I run a similar command at school with the same syntax all's OK.
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 Mon Apr 23 2001 - 22:20:41 CEST