I am using sqlplus to connect to an Oracle db from a shell script and the formatting is getting screwed up as below:
JOBNAME
--------------------------------------------------------------------------------
AVGRUNTIME SYSTIM AVGRUNTIMEFORMAT SYSTIMEFORMAT
------------ ------ -------------------- --------------------
FPDPPRL020
015322 211819 01:53:22 21:18:19
FPDPPRL020
014858 211819 01:48:58 21:18:19
~
Expected Output:
---------------
JOBNAME AVGRUNTIME SYSTIME AVGRUNTIMEFMT SYSTIMEFORMAT
FPDPPRL020 015322 211016 01:53:22 21:10:16
FPDPPRL020 014858 211016 01:48:58 21:10:16