Ok, I got the output cleaned up (thanks Sue!) but when I run this sql
from sql*plus, the output is formatted nicely. When Running same sql in
OEM job, some shifting occurs. Any ideas?
-----Original Message-----
Timestamp : Dec 01 2005 11:43:53 AM, PST
Job Output:
L1 Variances Between Ross and API
-------------------------------------------------------
PART LOT STATUS ROSS API DIFF
-------- --------------- ------ ------- ------- -------
10347 1034701072606 QOH 1 2 1
10814 1081402040406 QOH 627 710 83
-------
Total: 84
-----End Message-----
SQL in OEM:
===================
SET PAGESIZE 50
SET LINESIZE 80
SET VERIFY OFF
SET TIMING OFF
SET FEEDBACK OFF
TTITLE OFF
CLEAR COL
--
--
column datetime noprint new_value datetime
col PART format a8
col LOT format a15
col STATUS format a6
col ROSS format 99,999
col API format 99,999
col DIFF format 99,999
--
break on REPORT
compute sum label 'Total: ' of diff on REPORT
TTITLE LEFT '&1 Variances Between Ross and API' SKIP -
LEFT '-------------------------------------------------------'
SKIP 2
--
--
SELECT rtrim(PART_CODE) AS PART,
rtrim(IC_LOT_NUMBER) AS LOT,
rtrim(STATUS) as STATUS,
ROSS, API, abs(ROSS-API) AS DIFF
FROM MAN_PROD.INV_AUDIT
WHERE ROSS <> API
ORDER BY PART
;
Oracle LazyDBA home page