SELECT v.vehicle_id,v.vehicle_type, rep.report_id, rep.report FROM VE_MASTER vm ,VE_LOCATION_HIST vloc, REGION r, REPORT_DATA rep WHERE vm.VEHICLE_TYPE='001' and SDO_INSIDE ( vloc.location, r.area ) = 'TRUE' and r.name='新潟県' and vloc.timestamp > TO_TIMESTAMP('2023/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') and CONTAINS( rep.REPORT, 'ブレーキ or 制動機') > 0 and rep.date > TO_DATE('2023/01/01','YYYY/MM/DD') and vm.vehicle_id=vloc.vehicle_id and rep.report_id=vloc.report_id ORDER BY vector_distance ( DBMS_VECTOR.utl_to_embedding( '凍結の影響で故障やトラブルがあっ た'), rep.VECTOR ) APPROX FIRST 10 ROWS ONLY; Copyright (C) 2026, Oracle and/or the affiliates 42