|
|
Re: Bug in Oracle External Table Not display Decimal Values [message #657111 is a reply to message #657106] |
Fri, 28 October 2016 01:45 |
|
ninan
Messages: 163 Registered: June 2011 Location: Noida
|
Senior Member |
|
|
Then what is the point in having the table column declared as
CREATE TABLE "TESTMASK"
( "BALANCE" NUMBER(15,2)
)
And Fields position declared as
FIELDS LRTRIM MISSING FIELD VALUES ARE NULL (
BALANCE position (1:17) DECIMAL(15,2)
) )
or
BALANCE position (1:17) DECIMAL EXTERNAL
If I need to format using select statement. That is a bug for which no solution so far available from Oracle.
[Updated on: Fri, 28 October 2016 01:47] Report message to a moderator
|
|
|
|
Re: Bug in Oracle External Table Not display Decimal Values [message #657113 is a reply to message #657112] |
Fri, 28 October 2016 01:54 |
|
ninan
Messages: 163 Registered: June 2011 Location: Noida
|
Senior Member |
|
|
None of the documents have anything regarding this. Can you share if you think there exists some documentation on this.
I guess you work for Oracle and get enraged when people points out Bugs.
Bugs are bugs and you have to admit it. Oracle is not from Heaven, it is just a product , and you have to admit bugs, not being adamant and angry at it will not help anyone.
[Updated on: Fri, 28 October 2016 01:57] Report message to a moderator
|
|
|
|
|
Re: Bug in Oracle External Table Not display Decimal Values [message #657118 is a reply to message #657113] |
Fri, 28 October 2016 02:26 |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
ninan wrote on Fri, 28 October 2016 07:54Bugs are bugs and you have to admit it. Oracle is not from Heaven, it is just a product.
You are 100% right there. Problem is, that's the only thing that you are right about.
Why on earth would oracle assume that when you insert a value of 125 that you actually want a value of 1.25 simply because you have stated (in the column definition) that the column is capable of holding 2 decimal places (i.e. NOT that it MUST hold 2 decimal places, just that it CAN? That makes absolutely ZERO logical sense. Please, please understand that your understanding is VERY flawed here. You ask for documentation? Here you go:
https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#i16209
|
|
|
|