Toad World® Forums

using "AS" for column alias


#1

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


#2

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


#3

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.