Toad World® Forums

using "AS" for column alias


This returns data (one row), as you’d expect (one column with heading TEST_ME):
SELECT dummy test_me FROM DUAL;

But, if use “AS” for the column alias, it says the SQL Statement was executed, but no data is returned:
SELECT dummy AS test_me FROM DUAL;

Using the latest beta.



Thanks Charlie. I have raised story 49267991 for this issue.


Hi Charlie

We have fixed this issue already, you will see the changes in the next drop.

Now it can return data if use “AS” for the column alias.

Thank you.