Field with 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
  

Poston Thu, 13 Jan 2005 11:15 pm

Good morning to all, I would help to solve the following case: I want to bring a numerical field of 8 character in the following format ' 99999-999 ' without using the SUBSTR command.

Thank you.
moreira
Location: Sao Paulo

Poston Mon, 17 Jan 2005 7:41 am

Without using the substr command never seen ... Why don't you suddenly creates a function to do this.
lamanita
Location: Porto Alegre - RS

Samuel, o lamanit@

Poston Mon, 17 Jan 2005 8:02 am

I agree with the Lamanite.

I imagine that this field is a zip code that is being recorded as NUMBER. I think you can make a function for this.
dr_gori
Location: Portland, OR USA

Thomas F. G

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

Poston Tue, 21 Jun 2005 11:58 pm

If a field in an attempt to block a mask as follows ...

FM9999 \"-\" 999 not sure if it will work, I didn't have time to do the test. .. see if fünf. ...

[] 's
anderson
Location: Toledo - PR

Anderson Nuernberg
---



Return to PL/SQL

Who is online

Users browsing this forum: Bing [Bot] and 7 guests