Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE devices (
  name          VARCHAR2(30),
  configuration BLOB
);
INSERT INTO devices (name, configuration)
VALUES (
  'Door-Entrance',
  UTL_RAW.CAST_TO_RAW('<?xml version="1.0" encoding="UTF-8"?>
<properties>
   <port>8000</port>
   <ip>12.345.67.80</ip>
</properties>')
);
1 rows affected

SELECT d.*,
       extractvalue(xmltype(d.CONFIGURATION,nls_charset_id('AL32UTF8')),'properties/ip') as ip_lookup
FROM   /*AZ.*/DEVICES d
WHERE  NAME = 'Door-Entrance';


NAME
CONFIGURATION
IP_LOOKUP


Door-Entrance
<?xml version="1.0" encoding="UTF-8"?>
<properties>
   <port>8000</port>
   <ip>12.345.67.80</ip>
</properties>
12.345.67.80


SELECT *
FROM   /*AZ.*/devices d
       CROSS APPLY XMLTABLE(
         '/properties'
         PASSING XMLTYPE(d.configuration,nls_charset_id('UTF8'))
         COLUMNS
           port NUMBER(5,0)  PATH './port',
           ip   VARCHAR2(15) PATH './ip'
       ) x
WHERE  x.ip = '12.345.67.80';


NAME
CONFIGURATION
PORT
IP


Door-Entrance
<?xml version="1.0" encoding="UTF-8"?>
<properties>
   <port>8000</port>
   <ip>12.345.67.80</ip>
</properties>
8000
12.345.67.80


SELECT *
FROM   /*AZ.*/devices d
       CROSS APPLY XMLTABLE(
         '/properties[ip="12.345.67.80"]'
         PASSING XMLTYPE(d.configuration,nls_charset_id('UTF8'))
         COLUMNS
           port NUMBER(5,0)  PATH './port',
           ip   VARCHAR2(15) PATH './ip'
       ) x


NAME
CONFIGURATION
PORT
IP


Door-Entrance
<?xml version="1.0" encoding="UTF-8"?>
<properties>
   <port>8000</port>
   <ip>12.345.67.80</ip>
</properties>
8000
12.345.67.80