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.
source
share