Hi,
I'm trying to do this in Oracle:
SELECT T.emm
FROM (select 'abc' as emm from dual) T
where T.emm = 'abc'
ORDER BY T.emm;
I get no rows.
When I leave out the WHERE phrase it works. Anyone any idea on why?
I've also tried the same thing with a WITH statement, but results are the same.
(I know this is an oracle question, but I'm still waiting for anyone to reply over there).
Oracle 19c.
TIA
MiguelL
I just received the same answer on the Oracle forum and you are right!.
I have no idea how that character has appeared there. I've copied some text from a result set in SQL Developer. That must be the culprit!
Thank you very much, problem solved.
regards,
MiguelL