I have a SQL query that create a report. Tthis is a part of the query where I bring the Item No.
,LOM.QTY "LOM Qty"
,HK.FIGNUMHK "Fig. No."
,HK.ITEMNOHK "Item No."
,XI.TMNUMBXI "TM No."
My problem is that HK.ITEMNOHK is a Varchar2(4) format
The data look like that
1-8
1-9
1-10
1-11
When I export it to a CSV file it change to data format and I get this
1-8
1-9
1 Oct
1 Nov
Is there a way to force the real value (format)