Personal aqui in our database the values ??are registered in number format, however when will I make web applications picking up these values ??they are returned so?
1
10
100
1000
285
15.99
258.69
]
ok I would like to know if you have how to mount in select something that already brings the shots formatted in our currency in this way below
1,00
10.00
100.00
1,000.00
285.00
15.99
258.69
values ??format oracle
-
- Moderador
- Posts: 2016
- Joined: Wed, 12 Jan 2005 3:25 pm
- Location: Araraquara - SP
Abraço,
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Brother, beleza?
Try this formatting:
See the table of formats here: http://en.glufke.net/oracle/viewtopic.php?f=3&t=10856
Anything, send us.
Try this formatting:
select to_char(19.00,'999D99') from dual;
Anything, send us.
-
- Rank: Estagiário Júnior
- Posts: 1
- Joined: Fri, 24 Jul 2009 5:55 pm
- Location: recife - pe
You can also use the Masker Mask '999G999G999G999999' that would be: 999.999.999.999.99
In case the "G" is the point of a thousand. millions, billions and etc, and the "d", would be the decimal point or virgule, this way it will follow according to the NLS_Language, and if it is used in another language, it will appear in the right format, and you do not need to change .
Hugs,
In case the "G" is the point of a thousand. millions, billions and etc, and the "d", would be the decimal point or virgule, this way it will follow according to the NLS_Language, and if it is used in another language, it will appear in the right format, and you do not need to change .
Hugs,
-
- Information
-
Who is online
Users browsing this forum: No registered users and 12 guests