Numerical formatting in Portugues (999,999,999 .00)

Dicas do Oracle Forms Builder - Blocos, Itens, LOV, Canvas, Triggers, comandos, PLL, d2kwutil, FMB, Alert, menus, etc

Poston Thu, 03 Mar 2005 2:15 pm

Please friends, I wonder how I can use numerical formatting in Portugues (999,999,999 .00) in the forms in the \"format mask\" he only accepts formatting in English?! could someone help me?!

Note: I know q in reports has as I change the commas per point ... q will in forms has something?!
Location: São Paulo

Poston Thu, 03 Mar 2005 9:41 pm

Hello dear friend when I needed to do this so I thought one way. ...
Go to regedit and modify NLS_LANGUAGE where machine is installed the runtime.

Ats, Romulus
Location: SP


Poston Mon, 04 Apr 2005 2:29 pm

I use the following mask 999G999G990D00 kind regards Alessandro

Poston Wed, 08 Jun 2005 1:08 pm

Use the following mask: FM999G999G990D00 where: FM removes white spaces from the field;
the G is the thousand separator;
the D is the decimal separader.

But keep in mind that this depends on the configuration of your bank.
Location: Toledo - PR

Anderson Nuernberg

Poston Tue, 18 Aug 2009 10:52 am

need a mask q boat comma from the second number não more I'm getting ... looked the more aqui não response worked .... someone please help mi????

Thank you.
Location: Gaspar-SC

Jeziel Peres

PL/SQL - Forms 6i

Poston Wed, 16 Jun 2010 5:11 pm

Guys I will post here so you don't have to create another topic ...

I made a screen in Forms 6i and put the following mask for CNPJ:
Code: Select all
However, I need the Forms record the points in the database too, how do I?

Location: São Paulo/SP

Rafael S. Nunes
São Paulo/SP

Poston Thu, 17 Jun 2010 12:01 pm

Rafael, I believe that you will only be able to store information with dots and BARS if the type of the field in the database is varchar.

Hugs ...
Location: São Paulo, SP


Poston Thu, 17 Jun 2010 12:30 pm

the field is VARCHAR.

I used this tip from hyebahi on the topic: viewtopic.php?t=1409&highlight=mascara
Code: Select all
SELECT decode(cpf
             ,translate(to_char(cpf / 100, '000,000,000.00'), ',.', '.-')) cpf_com_mascara
       ,regexp_replace(cpf,'([0-9]{3})([0-9]{3})([0-9]{3})([0-9]{2})','1.2.3-4') cpf_com_mascara_regexp
  FROM ((SELECT '12345678912' cpf
               ,'12345678000189' cnpj
           FROM dual))
* remembering that the CNPJ needed be adapted/corrected, that testing inside the Bank to see how it worked but in the Forms, only worked for CPF because the regexp_replace function ' does not work within the Forms and I didn't want também:(create an external function (in the Bank) to do this.

It was only the formatting for the CPF.
Location: São Paulo/SP

Rafael S. Nunes
São Paulo/SP

  • See also
    Last Post

    Return to Forms

    Who is online

    Users browsing this forum: No registered users and 6 guests