SQL & PL/SQL

Folks, I have a below XML stored within table, column type XMLTYPE.

I would like to extract all data from it by using some simple query + later insert returned rows into some dummy table.

This should be an easy task for somebody who is using XML on daily basis.

<env:Envelope xmlns:env='http://schemas.xmlsoap.org/soap/envelope/'>
  <env:Header></env:Header>
  <env:Body>
    <ns1:getVehiclesResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns1="http://wirelesscar.com/dynafleet/api/types">
      <result>
        <vehicleInfos>
          <displayName>TRUCK 1</displayName>
          <vehicleId>
            <id>15631444</id>
          </vehicleId>
        </vehicleInfos>
        <vehicleInfos>
          <displayName>TRUCK 2</displayName>
          <vehicleId>
            <id>1564652</id>
          </vehicleId>
        </vehicleInfos>
        <vehicleInfos>
          <displayName>TRUCK 3</displayName>
          <vehicleId>
            <id>15634543</id>
          </vehicleId>
        </vehicleInfos>
      </result>
    </ns1:getVehiclesResponse>
  </env:Body>
</env:Envelope>

XML is stored in table TEST_XML column XML_DATA:

 select  ...
           extract(dr.response_env, '//result/vehicleInfos/displayName/text()').getStringVal()
   from TEST_XML

I would like to extract all nodes from <result> through some query.

Kind regards,
Tomas