How to make result returned from oracle keep case of characters in columns

I am trying to query the oracle database in sql database again.

I use Java ResultSetMetaDatato get the column names of aliases (by: rsmd.getColumnLable())

The request looks like this:

select part_id partId, part_num partNumber from tbl;

But the result set metadata returns me aliases as partidwell partnumberrespectively ...

But I need to get aliases in the same character that the user selects, so I need to get it as partidwell, partnumberrespectively.

How to do it?

Thank.

+5
source share
1 answer

, oracle, :

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

, , , jdbc.

+14

All Articles