求一条两个字段比较的sql语句

Question

ITSM INTERNET IP    MONITORING INTERNET IP IF IP CHANGED
195.33.106.100             195.33.106.100             Y
87.101.149.34,87.101.149.35     87.101.149.34             Y
205.177.226.26,205.177.226.24,205.177.226.26,205.177.226.24 205.177.226.26 Y
62.14.247.19,62.14.247.20     62.14.247.19              Y
94.27.13.42,94.27.13.46     94.27.13.42                Y
190.221.22.2,190.221.22.3       190.221.22.2             Y 
194.154.64.56,194.154.64.57     194.154.64.56              Y
后面一个ip 跟前面的ip比较 如果相同  IF IP CHANGED就是y
如果不相同则 IF IP CHANGED为N
ITSM INTERNET IP   可能包括几个ip地址  ,分开的

Answer 1

if IP1=IP2 else CHANGED=‘Y’ then CHANGED=‘n’

Answer 2

如果 第一个字段 ip 有多个ip呢？？？

Answer 3

SQL> WITH t AS (
  2  SELECT '192.168.1.1' ip1,'192.168.1.1' ip2 FROM DUAL UNION ALL
  3  SELECT '192.168.1.1' ip1,'192.168.1.2' ip2 FROM DUAL UNION ALL
  4  SELECT '192.168.1.3' ip1,'192.168.1.22  192.168.1.3' ip2 FROM DUAL
  5  )
  6  select ip1,
  7         ip2,
  8         case when instr(ip1, ip2) > 0 then 'NO'
  9         else 'YES' END CASE
 10    from t
 11  /IP1         IP2                       CASE
----------- ------------------------- ----
192.168.1.1 192.168.1.1               NO
192.168.1.1 192.168.1.2               YES
192.168.1.3 192.168.1.22  192.168.1.3 YESSQL> 

Answer 4

如果两个字段都存在多个ip，这个最好写一段pl/sql来解决