Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Database Application Development
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 17, 2013 2:58 AM by
Column alias not displaying when connecting to MySQL
Apr 16, 2013 9:33 PM
select col_name col_alias from table;
The query runs fine, but I get col_name displayed rather than col_alias. I did a search but can't seem to find any similar cases. Any ideas?
SQL Developer 3.0.04 connecting to MySQL 5.1.66.
This content has been marked as final.
Show 1 reply
Re: Column alias not displaying when connecting to MySQL
Apr 17, 2013 2:58 AM
in response to
Using SQL Dev 3.2 and 3.0 works for me when connecting to Mysql 5.5:
select empno as col1 from gateway.GTW_EMP;
select empno col1 from gateway.GTW_EMP;
returns in both cases:
did you try it in MySQL natively?