1 2 Previous Next 16 Replies Latest reply: Dec 6, 2012 11:40 AM by jihuyao Go to original post RSS
      • 15. Re: using range of values in like
        BluShadow
        3360 wrote:
        vaibhav wrote:
        Because i want the solution using ansi sql functions.
        Regular expressions are ANSI standard
        maybe, but the functions that allow for regular expressions to be used are called different things in different databases. ;)
        • 16. Re: using range of values in like
          jihuyao
          Here is another way, create a view letters and use it with instr function as filter
          SQL> ed
          Wrote file afiedt.buf
          
            1  create or replace view letters as
            2  select chr(ascii('A')+rownum-1) letter from dual
            3* connect by rownum<=ascii('Z')-ascii('A')+1
          SQL> /
          
          View created.
          
          SQL> select * from letters where letter between 'A' and 'G' ;
          
          LE
          --
          A
          B
          C
          D
          E
          F
          G
          1 2 Previous Next