Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trouble with a postal code

jerry44Jun 11 2014 — edited Jun 12 2014

Hi everyone. I'm in trouble with postal code. The problem is that the mask of code is 00-000 and in base i've field number(5). The result I desire is to have interface human friendly to make user unable put code with mask for example 0-0000 or 000-0 or 000-00, just 00-000. I thought about two boxes one for 00 and second for 000. Second functionality that relates to the problem is presentation, if the solution is based on two fields/columns there probably will be needed concatenation. But in my opinion atomizing code that there would be 2 collumns [00] and [000] is probably bad solution. The target is to show on repports properely [00-000] and create interface in form to fill it with cone in the [00-000] format, display in repports in format [00-000] and of course save to the base and load. If somebody has idea how to resolve the problem, please write it down

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2014
Added on Jun 11 2014
7 comments
2,982 views