--Script to create a data file with custom header--
--To run file execute at command prompt sqlplus @<filename>
usercad/usercad@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.109.99.100)(PORT=1800))(CONNECT_DATA=(SERVICE_NAME=WhTVR)))
SET PAGESIZE 0
SET LINESIZE 20
SET term off
SET feed off
SET underline off
SPOOL C:\Users\userid\GIT\project\sql\JobID.dat
PROMPT JobID
select something from sometable;
SPOOL OFF
quit
--Script to get data for some period of time --
select sbj_no from sjb where sbj_no in(
select sbj_no from prj.sbj_activity where CREATED_DATETIME > sysdate - interval '1' day and ASSIGN = 'N'
)
and INIT_SERVICE_CODE IN ('name1', 'name2', 'name3')
and sbj_no not in(select sbj_NO from prj.sbj_activity where ACTIVITY_CODE = 'actcode')
order by created_datetime desc fetch first 100 row only
select count(isr_no) from C07_isr_activity where C07_ACTIVITY_CODE = 'CL' and C07_START_DATETIME >= to_date('01 MAY 2021', 'DD MON YYYY')