CREATE TABLE tablea AS

SELECT '12.1.0.2.220718' database_version, 'JUL_2022' patch_release FROM dual

UNION ALL SELECT '19.16.0.0.220719', 'JUL_2022' FROM dual

UNION ALL SELECT '12.2.0.1.220719', 'JUL_2022' FROM dual

;

CREATE TABLE tableb AS

SELECT 'ABCD' db_name, 'Database Jul 2022 Release Update : 12.1.0.2.220718' description FROM dual

UNION ALL SELECT 'XYZ', 'Database Jul 2022 Release Update : 19.16.0.0.220719' FROM dual

UNION ALL SELECT 'PQRS', 'Database Jul 2022 Release Update : 12.2.0.1.220719' FROM dual

;

SELECT b.db_name, a.patch_release

  FROM tableb b

  INNER JOIN tablea a

  ON a.database_version = SUBSTR( b.description, INSTR( b.description, ' : ' ) + 3 )

;

SQL> SELECT b.db_name, a.patch_release

  2  FROM tablea a, tableb b

  3  WHERE REGEXP_LIKE(b.description, a.database_version)

  4  /

DB_N PATCH_RE

---- --------

ABCD JUL_2022

XYZ  JUL_2022

PQRS JUL_2022



3 rows selected.