안녕하세요

배우고 있는 중인데

쉘 스크립트에서

sqlplus user/password@ctrlm 오라클에 접속해서

select a.jobname, a.creationdatetime, b.jobname, b.creationdatetime from
(select * from cms_jobdef where schedtab ='TEST1') a
full outer join
(select * from cms_jobdef where schedtab ='TEST2') b
on
nvl(a.JOBNAME    , 'NULL') = nvl(b.JOBNAME    ,'NULLl')
where
nvl(a.DESCRIPT    , 'NULL') != nvl(b.DESCRIPT    ,'NULLl') or
nvl(a.AUTHOR    , 'NULL') != nvl(b.AUTHOR    ,'NULLl') or
nvl(a.OWNER    , 'NULL') != nvl(b.OWNER    ,'NULLl') or
nvl(a.PRIORITY    , 9) != nvl(b.PRIORITY    ,9) or
nvl(a.CRITICAL    , 'NULL') != nvl(b.CRITICAL    ,'NULLl') or
nvl(a.CYCLIC    , 'NULL') != nvl(b.CYCLIC    ,'NULLl') or
nvl(a.RETRO    , 'NULL') != nvl(b.RETRO    ,'NULLl') or
nvl(a.AUTOARCH    , 'NULL') != nvl(b.AUTOARCH    ,'NULLl') or
nvl(a.TASKCLASS    , 'NULL') != nvl(b.TASKCLASS    ,'NULLl') or
nvl(a.CYCLICINT    , 'NULL') != nvl(b.CYCLICINT    ,'NULLl') or
nvl(a.TASKTYPE    , 'NULL') != nvl(b.TASKTYPE    ,'NULLl') or
nvl(a.DATEMEM    , 'NULL') != nvl(b.DATEMEM    ,'NULLl') or
nvl(a.NODEGRP    , 'NULL') != nvl(b.NODEGRP    ,'NULLl') or
nvl(a.PLATFORM    , 'NULL') != nvl(b.PLATFORM    ,'NULLl') or
nvl(a.NODEID    , 'NULL') != nvl(b.NODEID    ,'NULLl') or
nvl(a.DOCLIB    , 'NULL') != nvl(b.DOCLIB    ,'NULLl') or
nvl(a.DOCMEM    , 'NULL') != nvl(b.DOCMEM    ,'NULLl') or
nvl(a.MEMLIB    , 'NULL') != nvl(b.MEMLIB    ,'NULLl') or
nvl(a.MEMNAME    , 'NULL') != nvl(b.MEMNAME    ,'NULLl') or
nvl(a.OVERLIB    , 'NULL') != nvl(b.OVERLIB    ,'NULLl') or
nvl(a.MAXRERUN    , 9) != nvl(b.MAXRERUN    ,9) or
nvl(a.MAXDAYS    , 9) != nvl(b.MAXDAYS    ,9) or
nvl(a.MAXRUNS    , 9) != nvl(b.MAXRUNS    ,9) or
nvl(a.FROMTIME    , 'NULL') != nvl(b.FROMTIME    ,'NULLl') or
nvl(a.UNTIL    , 'NULL') != nvl(b.UNTIL    ,'NULLl') or
nvl(a.MAXWAIT    , 9) != nvl(b.MAXWAIT    ,9) or
nvl(a.DAYSTR    , 'NULL') != nvl(b.DAYSTR    ,'NULLl') or
nvl(a.WDAYSTR    , 'NULL') != nvl(b.WDAYSTR    ,'NULLl') or
nvl(a.MONTHSTR    , 'NULL') != nvl(b.MONTHSTR    ,'NULLl') or
nvl(a.CONF    , 'NULL') != nvl(b.CONF    ,'NULLl') or
nvl(a.UNKNOWNTIM    , 9) != nvl(b.UNKNOWNTIM    ,9) or
nvl(a.DAYSCAL    , 'NULL') != nvl(b.DAYSCAL    ,'NULLl') or
nvl(a.WEEKCAL    , 'NULL') != nvl(b.WEEKCAL    ,'NULLl') or
nvl(a.CONFCAL    , 'NULL') != nvl(b.CONFCAL    ,'NULLl') or
nvl(a.CAL_ANDOR    , 'NULL') != nvl(b.CAL_ANDOR    ,'NULLl') or
nvl(a.SHIFT    , 'NULL') != nvl(b.SHIFT    ,'NULLl') or
nvl(a.ADJUST_COND    , 'NULL') != nvl(b.ADJUST_COND    ,'NULLl') or
nvl(a.STARTENDCYCIND    , 'NULL') != nvl(b.STARTENDCYCIND    ,'NULLl') or
nvl(a.CREATIONUSERID    , 'NULL') != nvl(b.CREATIONUSERID    ,'NULLl') or
nvl(a.CHANGEUSERID    , 'NULL') != nvl(b.CHANGEUSERID    ,'NULLl') or
nvl(a.RELATIONSHIP    , 'NULL') != nvl(b.RELATIONSHIP    ,'NULLl') or
nvl(a.GROUPID    , 9) != nvl(b.GROUPID    ,9) or
nvl(a.TABROWNO    , 9) != nvl(b.TABROWNO    ,9) or
nvl(a.MULTIAGENT    , 'NULL') != nvl(b.MULTIAGENT    ,'NULLl') or
nvl(a.APPLTYPE    , 'NULL') != nvl(b.APPLTYPE    ,'NULLl') or
nvl(a.TIMEZONE    , 'NULL') != nvl(b.TIMEZONE    ,'NULLl') or
nvl(a.STATEMSK    , 'NULL') != nvl(b.STATEMSK    ,'NULLl') or
nvl(a.APPLVER    , 'NULL') != nvl(b.APPLVER    ,'NULLl') or
nvl(a.TIMEREF    , 'NULL') != nvl(b.TIMEREF    ,'NULLl') or
nvl(a.ACTFROM    , 'NULL') != nvl(b.ACTFROM    ,'NULLl') or
nvl(a.ACTTILL    , 'NULL') != nvl(b.ACTTILL    ,'NULLl') or
nvl(a.CMVER    , 'NULL') != nvl(b.CMVER    ,'NULLl') or
nvl(a.APPLFORM    , 'NULL') != nvl(b.APPLFORM    ,'NULL');

문장을 수행하고 test1과 test2가 변하지 않았으면 exit 0;을 아니면 exit 1;

내보내는 쉘 스크립트를 작성하고 싶은데요, 어렵네요 가르쳐 주세요