Re: finding SQL that doesn't have bind variables
- From: Phillip Jones <phil@xxxxxxxxxx>
- To: oracledbaquestions@xxxxxxxxx
- Date: Fri, 16 Mar 2012 15:32:47 +0000
Hi,
You escape ' with an extra ', giving ''. So your insert would be:
insert into test values ('select 1 from mytable where x =''v'' and y =
''q''');
Same in regexps. eg:
PHILJ@phil112 > select regexp_replace('foo''foo','''','@') from dual;
REGEXP_
-------
foo@foo
PHILJ@phil112 >
Cheers,
Phil
On Fri, Mar 16, 2012 at 3:05 PM, Dba DBA <oracledbaquestions@xxxxxxxxx>wrote:
>
> -- sql is basically 2 parts. inner part gets changes anything between
> single quotes to an @(the translate turns the single quote to an @. I was
> having trouble passing single quotes to
> a regular expression so I just turned the quotes into an @.
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
