Mask

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
Post Reply
moreira
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Thu, 13 Jan 2005 11:05 pm
Location: são Paulo

Good morning to all,

I would like to help to solve the sequentage case:
I want to bring a number of 8 character in the sequin
format '99999-999 'Without using the substr command.

Thanks.
lamanita
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 42
Joined: Mon, 17 May 2004 2:41 pm
Location: Porto Alegre - RS
Samuel, o lamanit@

Without using the substr command never saw ... suddenly why you do not create a function that does it ...
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

I agree with the Lamanite ...

I imagine this field is a zip code that is being recorded as a number. I think you can do a function for this.
User avatar
anderson
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 75
Joined: Mon, 06 Jun 2005 1:08 pm
Location: Toledo - PR
Contact:
Anderson Nuernberg
---

If it is a field in a block try putting a mask in the following way ...

FM9999 "-" 999

I'm not sure if it will work, no I had time to take the test ...
see ai if funciona ....

[] 's
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 11 guests