This content has been marked as final. Show 1 reply
930254 wrote:select ASCIISTR(id) from tab1 where id like 'A%';
I am using Release 10.2.0.1.0 version of oracle. I am getting a special character, but i suspect it as any other language caharacter.
Its appearing in my 'TOAD editor/Sql prompt editor' as 'A?'. but when i am selecting it from the table using below query, its giving 'No rows Returned'.
select id from tab1 where id like 'A%';
Please let me know, how can i be able to see the exact character or which editor will enable me to see the character?
I think sql developer GUI might be able to show the same but i dont have sql developer with me.