| FORMAT OF DATA IN FORMS 6i [message #678440] |
Wed, 04 December 2019 05:27  |
 |
Boumati
Messages: 21
Registered: November 2019
|
Junior Member |
|
|
Hi,
thank you for telling me, the displaying format, to force the sign (+ or -) of the input data in the oracle/form 6i
thanks a lot by advance.
|
|
|
|
| Re: FORMAT OF DATA IN FORMS 6i [message #678480 is a reply to message #678440] |
Sun, 08 December 2019 13:49  |
 |
Littlefoot
Messages: 21783
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Can't test on Forms right now, but you can check whether the S format mask helps, such as in this example:
SQL> select to_char(1234, 'S999g990d00') positive,
2 to_char(-123, 'S999g990d00') negative
3 from dual;
POSITIVE NEGATIVE
----------- -----------
+1.234,00 -123,00
SQL> |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
