Re: SPOOL INTO A JOB
Date: Sat, 06 Sep 2008 00:24:43 +0200
On Fri, 5 Sep 2008 12:36:00 -0700 (PDT), CenturionX <darwinbaldrich_at_gmail.com> wrote:
>I'm working with Oracle 10g.
>I have a report generated by a sql script. This script runs in a
>I have to generate this report from the database now.
>The report like that (I modified it for confidential issues):
>set feedback off
>set pages 50
>set lines 80
>COL TIMESTAMP NEW_VALUE xTIMESTAMP noprint format a1 trunc
>COL BAR FORM a7 HEADING 'BAR'
>COL COMPONENT FORM a15 heading 'COMPONENT'
>COL AGGBALANCE heading 'AGG. BALANCE'
>break on BAR skip 1
>ttitle center 'MY REPORT' skip 1-
> center '====================================' skip 2
>btitle left ' ' skip 2 -
> left 'Time of Report: ' xTIMESTAMP skip 2 -
> center 'Page: ' format 999 SQL.PNO
>SELECT sysdate from dual
>My question is if i can run that script like this from a job.
Next question to be expected 'How'
My answer: You didn't ask that. Also you didn't specify an exact version and a platform.
-- Sybrand Bakker Senior Oracle DBAReceived on Fri Sep 05 2008 - 17:24:43 CDT