Hi,
Can you please advise how to compare 2 .txt files in Oracle.
Here is the sample files
File1.txt
--------
/* ----------------- Orac_Status ----------------- */
insert_job: Orac_Status job_type: CMD
command: script1.sh
machine: dev.net
owner: scot@db1
permission:
date_conditions: 1
days_of_week: tu,we,th,fr,sa
start_times: "01:30,03:30,05:30,07:00"
description: "files_stat"
std_out_file: "files_stat.out"
std_err_file: "files_stat.err"
max_run_alarm: 300
alarm_if_fail: 1
/* ----------------- Adam_Orac----------------- */
insert_job: Orac_Status job_type: CMD
command: script4.sh
machine: PROD.net
owner: scot@db1
permission:
date_conditions: 1
days_of_week: tu,we,th,fr,sa
start_times: "03:30,05:30,07:00"
description: "files_ecli"
std_out_file: "files_stat_hyt.out"
std_err_file: "files_stat_try.err"
max_run_alarm: 300
alarm_if_fail: 1
etc.. -- 1000 lines
FILE2.txt
/* ----------------- Adam_Orac----------------- */
insert_job: Orac_Status job_type: CMD
command: script1.sh
machine: dev.net
owner: scot@db1
permission:
date_conditions: 1
days_of_week: tu,we,th,fr,sa
start_times: "01:30,03:30,05:30,07:00"
description: "files_stat"
std_out_file: "files_stat.out"
std_err_file: "files_stat.err"
max_run_alarm: 300
alarm_if_fail: 1
/* ----------------- HyaT_Orac----------------- */
delete_job: XYS_Status
job_type: ABC
command: script8.sh
machine: UAT.net
owner: VISI@db1
permission:
date_conditions: 1
days_of_week: tu,we,th,fr,sa
start_times: "09:00,09:30"
description: "this will run daily 2 times"
std_out_file: "twice_run.out"
std_err_file: "run_twice.err"
max_run_alarm: 500
alarm_if_fail: 1
Advise how to compare this files in Oracle.
Thanks