set lines 130
alter session set nls_date_format=’DD-MON-YY HH24:MI:SS’;
select APPS_SYSTEM_NAME,DRIVER_FILE_NAME,start_date,end_date
from AD_PATCH_RUNS a,AD_PATCH_DRIVERS b
where a.PATCH_DRIVER_ID = b.PATCH_DRIVER_ID and DRIVER_FILE_NAME like ‘%&Patch_number%’;
alter session set nls_date_format=’DD-MON-YY HH24:MI:SS’;
select APPS_SYSTEM_NAME,DRIVER_FILE_NAME,start_date,end_date
from AD_PATCH_RUNS a,AD_PATCH_DRIVERS b
where a.PATCH_DRIVER_ID = b.PATCH_DRIVER_ID and DRIVER_FILE_NAME like ‘%&Patch_number%’;
Recent Posts