Hello Friends,
I have one problem with decimal values. Here is scenario.
CREATE TABLE TEST
(ID NUMBER(3,0),
VALUE NUMBER(5,2));
INSERT INTO TEST VALUES(1,0.22);
INSERT INTO TEST VALUES(2,1.22);
INSERT INTO TEST VALUES(3,55.22);
INSERT INTO TEST VALUES(4,666.22);
INSERT INTO TEST VALUES(5,2.2);
INSERT INTO TEST VALUES(6,22);
INSERT INTO TEST VALUES(7,58.6);
COMMIT;
Now if I fire a select query here by concatenating value column with a string observe the result.
select VALUE, value||' cm' from test;
Value
| Value with String
|
|---|
| 0.22 | .22 cm |
| 1.22 | 1.22 cm |
| 55.22 | 55.22 cm |
| 666.22 | 666.22 cm |
| 2.2 | 2.2 cm |
| 22 | 22 cm |
| 58.6 | 58.6 cm |
Observe First Record. My actual Value is 0.22. Why It is showing .22
Thanks in Advance.