Patching

1.Patch details with date and Node details

set pagesize 1000
set linesize 130
col "PATCH NAME" for a15
col "NODE NAME" for a15
col PLATFORM for a13
col "FILE NAME" for a15
select a.name as "NODE NAME", b.driver_file_name as "FILE NAME",b.orig_patch_name as "PATCH NAME",
b.platform as "PLATFORM", done.language as "LANGUAGE", c.success_flag as "SUCCESS",
to_char(c.start_date,'dd-MON-yyyy hh24:mi:ss') as "START DATE",
to_char(c.end_date,'dd-MON-yyyy hh24:mi:ss') as "END DATE"
from
ad_appl_tops a,
ad_patch_drivers b,
ad_patch_runs c,
ad_patch_driver_langs done
where
b.patch_driver_id=c.patch_driver_id
and c.appl_top_id=a.appl_top_id
and done.patch_driver_id=c.patch_driver_id
and b.orig_patch_name like '%&patch_number'
order by 1;