Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> BREAK statement

BREAK statement

From: Eric from Speco <eric_at_speco.com>
Date: Tue, 3 Jul 2001 11:17:54 -0500
Message-ID: <9hsr9e$91s$1@bob.news.rcn.net>

This script won't run correctly. I get the data but no break. Any help is much appreciated

BREAK ON hd.t$orno SKIP 1

SELECT hd.t$orno, hd.t$cuno, hd.t$odat, ln.t$item, ln.t$pric   FROM baan.ttdsls040100 hd, baan.ttdsls041100 ln WHERE hd.t$orno = ln.t$orno

     AND hd.t$cotp like '%SR1%'
     AND hd.t$odat > sysdate - 90
ORDER BY hd.t$orno;

Is there an enviornment variable I need to change on my machine to make this work?

release 703040001 Received on Tue Jul 03 2001 - 11:17:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US