11 Replies Latest reply: Feb 26, 2013 2:10 AM by nkvkashyap RSS

    instr doubt

    user in
      Oracle Database 10g Release 10.2.0.4.0 - Production
      PL/SQL Release 10.2.0.4.0 - Production
      CORE 10.2.0.4.0 Production
      TNS for 32-bit Windows: Version 10.2.0.4.0 - Production
      NLSRTL Version 10.2.0.4.0 - Production

      how can i check for single quotes in an instr function
      select instr('hello',''')
      from dual;
      ERROR:
      ORA-01756: quoted string not properly terminated

      i want to know whether this is possible or not