用來比較兩個字符串從第幾個位置開始不相同

  • A+
所属分类:mysql教程
摘要

适用於Oracle資料庫的SQL Oracle SQL 字符串 select min(level) from dual where nvl(substr(‘字串1′,level,1),’ ‘)nvl(substr(‘字串2′,level,1),’ ‘) connect by level=200

适用於Oracle資料庫的SQL Oracle SQL 字符串 select min(level) from dual where nvl(substr('字串1',level,1),' ')nvl(substr('字串2',level,1),' ') connect by level=200

适用於Oracle資料庫的SQL

Oracle SQL 字符串

select min(level) 
  from dual 
 where nvl(substr('字串1',level,1),' ')<>nvl(substr('字串2',level,1),' ') 
connect by level<=200

除非注明,否则均为@蒲公英网原创文章,转载必须以链接形式标明本文链接

本文链接:https://www.aipgy.com/411427.html

avatar

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: