How I can search for this special character
`!@#$%^&*_=[]{};<>
I have try with this code but not work that I expect
select
*
from table
where
regexp_like (A, '[^0-9A-Za-z[:space:],.-]' )
or regexp_like (B, '[^0-9A-Za-z[:space:],.-]' )
or regexp_like (C, '[^0-9A-Za-z[:space:],.-]' )
or regexp_like (D, '[^0-9A-Za-z[:space:],.-]' )
or regexp_like (E, '[^0-9A-Za-z[:space:],.-]' )
I have:
column_A column_B column_C column_D column_E
I need:
but 'ąśćół' is normal polish letter and for me this is not special character also - . , and ENTER (new line) is accepted
This work that I expect
select
*
from table
where
column_A != NVL ( TRANSLATE ( column_A
, 'A`!@#$%^&*_=[]{};\<>'
, 'A'
)
, 'A'
)
column_B != NVL ( TRANSLATE ( column_B
, 'A`!@#$%^&*_=[]{};\<>'
, 'A'
)
, 'A'
)
column_C != NVL ( TRANSLATE ( column_C
, 'A`!@#$%^&*_=[]{};\<>'
, 'A'
)
, 'A'
)
column_D != NVL ( TRANSLATE ( column_D
, 'A`!@#$%^&*_=[]{};\<>'
, 'A'
)
, 'A'
)
column_E != NVL ( TRANSLATE ( column_E
, 'A`!@#$%^&*_=[]{};\<>'
, 'A'
)
, 'A'
)