Untitled

i want you to write the sql quaries information into log kind of sql file which is present in the path /app/scripts/PPM_Release_Management/Product_Catalog_ETL/logs/ppm_reply.sql
the below is sample sql information that you need to write in sql log file
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ STATUS|ppm_replication_status
-- #Query: Result:{1}
UPDATE tibtcare_ppm.ppm_replication_status SET status='InProgress', status_message='Directory/Configuration file evaluation successful', error_description='INFO: Processing step {1/4}', updated_by='REP_999' , updated_date=SYSDATE WHERE replication_job_id='REP_999' AND release_id='1178.3'
;
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ STATUS|ppm_release_master
-- #Query: Result:{1}
UPDATE tibtcare_ppm.ppm_release_master SET replication_status='InProgress', updated_by='REP_999' , updated_on=SYSDATE WHERE release_id='1178.3'
;
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++|FETCH_ETL_PPM_MASTER|PPM_REPLICATION
-- #Query:
SELECT eppm.*
  FROM tibtcare_ppm.etl_ppm_replication_master eppm
 WHERE eppm.eprm_catalog IN ('RELEASE', 'PC', 'PC-TRACE')
;
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++|FETCH_DB_OBJECTS|SOURCE|PPM_REPLICATION
-- #Query:
SELECT UPPER(atc.table_name) AS "table_name", LISTAGG(lower(atc.column_name), ',') WITHIN GROUP (ORDER BY /*atc.column_id*/ atc.column_name) AS "column_names", LISTAGG(lower(atc.column_name)||CASE WHEN atc.data_type='VARCHAR2' Then '-{VARCHAR2(' || atc.data_length ||')' ELSE NULL END, ',') WITHIN GROUP (ORDER BY atc.column_name) AS "column_name_and_type" 
  FROM ALL_TAB_COLS atc
 
you should write ever information beside query like replicationTarget,replicationJobId