SQL plus help for Newbie

From: Eric from Speco <eric_at_speco.com>
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
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 Mon Apr 23 2001 - 22:20:41 CEST

Original text of this message