I have a table table1 with a varchar column column1 having a value(ASW'JK'TH)(the column value itself has special charater'').Please help me with a quwery to filter this value
Please provide DB version and some sample data with required output.
Try regular expression like this.
where regexp_like(column1, '[^[:alnum:]]')
What is special character?
Can you paste here examples ?
with data as
(select 'ASW''JK''TH' as val from dual )
select val from data
where val like '%JK%';
I think you can use LIKE operation in where clause.
We can filter the special characters by using the translate function or regular expressions.
db version is 11g:
in_identifer VARCHAR2 (200) := q'[RM'2007'29]';
I need where condition for a tabel coumn with teh above value
I have the exact value of the column as input.Henc i should use =