I have 2 expressions "case" that select values from XML type column but the rows in the target table contains values "IP address" и "ip address".
How to combine 2 "case" expressions into one field with the conditions for searching for entries "IP address" and "ip-address" into target table?
,case when length(table.description)>0 then xmltype(table.description).extract('//text[@label="IP adress"]/text()').getstringval() else null end"IP"
,case when length(table.description)>0 then xmltype(table.description).extract('//text[@label="ip adress"]/text()').getstringval() else null end"ip"