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

程序员文章站 2023-12-30 13:56:58

...

适用於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