How to make the resultset returned from oracle keeps its column aliases characters case

I am trying to querying some sql statment againest oracle database.

I am using Java ResultSetMetaData to get column alias names (through: rsmd.getColumnLable() )

The query looks 开发者_Go百科like:

select part_id partId, part_num partNumber from tbl;

But the result set meta-data returns for me the aliases as partid and partnumber respectively ...

But I need to get the aliases in the same characters case the user choose, so I need to get it as partId and partNumber respectively.

How to accomplish that?

Thanks.

Column names and aliases are case insensitive by default, if you want to preserve case in an oracle statement you could quote the names like this:

select part_id "partId", part_num "partNumber" from tbl;

In my tests the column names where returned in uppercase when not using the quotes, so the behaviour might also depend on the version of the jdbc driver.