Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> BREAK statement
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
![]() |
![]() |