Finding Special Characters in column.
Hi,
I am using Release 10.2.0.4.0 version of oracle.
Wanted to find out the different special character getting used in column c1, so using below query to get the result set.
SELECT DISTINCT
TRANSLATE (
c1,
'!""#$%&''()*+,-./:;<=>?@[\]^_`{|}~ 0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ',
'!""#$%&''()*+,-./:;<=>?@[\]^_`{|}~')
special_character
FROM tab1 ;
But in the result set, i got two values as
A?
e
but i am not expecting any of the Alaphabets in the resultset as because i only filterout the special characters.
So i wanted to find out the particular value of 'c1' which results in such kind of result. I executed below query but getting 'no rows selected'.
SELECT DISTINCT
TRANSLATE (
c1,
'!""#$%&''()*+,-./:;<=>?@[\]^_`{|}~ 0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ',
'!""#$%&()*+,-./:;<=>?@[\]^_`{|}~')
special_character
FROM tab1
WHERE TRANSLATE (
c1,
'!""#$%&''()*+,-./:;<=>?@[\]^_`{|}~ 0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ',
'!""#$%&''()*+,-./:;<=>?@[\]^_`{|}~ ') like '%e%' ;
So my question is, is there anyway i can get the 'rowids' along with the distinct special_character, so that i can get the reason behind such results.
(I can not analyze all the results as because the table is too big ti analyze all the records.)
Edited by: 930254 on Mar 13, 2013 3:55 AM
Edited by: 930254 on Mar 13, 2013 4:19 AM