Oracle instr用法

      
        select
      
       instr(
      
        '
      
      
        ->Oracle instr用法
      
      
        '
      
      ,
      
        '
      
      
        Oracle instr用法
      
      
        '
      
      ,
      
        1
      
      ,
      
        1
      
      ) 
      
        as
      
       i 
      
        from
      
       dual;  
    

      
        select
      
       instr(
      
        '
      
      
        oracle
      
      
        '
      
      ,
      
        '
      
      
        or
      
      
        '
      
      ) as i 
      
        from
      
       dual;
    

      instr(name,
      
        '
      
      
        aa’)>0 相当于like

instr(name,
      
      
        '
      
      aa’)
      
        =
      
      
        0
      
       相当于not 
      
        like