Using "as" in DUAL statement produces error
583525Jun 20 2007 — edited Jun 20 2007Hi,
SELECT 'abcefghijklm' AS str FROM DUAL WHERE str IN ('a','e','i','o','u');
This produces an error message - "STR": invalid identifier
Is such a comparison using a field name invented using "as" always invalid - is there no way around it?
What I am trying to do is to count the number of vowels in a sentence, there may be a better approach of course, if anyone knows one...?