select 'mkdir -p '|| regexp_replace(object_path, '/DICOM_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/DICOM/validatedDICOM' ||
 regexp_replace(object_path, '.*/DICOM','') || ' ' || object_path || ';' from dicom_validated_object ;

select 'mkdir -p '|| regexp_replace(object_path, '/validatorDetector_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/validatorDetector/validatorDetector' ||
 regexp_replace(object_path, '.*/validatorDetector','') || ' ' || object_path || ';' from object_for_validator_detector ;

select 'mkdir -p '|| regexp_replace(object_path, '/tlsCertificate_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/validatorDetector/validatorDetector' ||
 regexp_replace(object_path, '.*/validatorDetector','') || ' ' || object_path || ';' from object_for_validator_detector ;