OraFAQ Forum: Forms » mask credit card number with "xxxx xxxx xxxx 1234"

Home » Developer & Programmer » Forms » mask credit card number with "xxxx xxxx xxxx 1234"

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

mask credit card number with "xxxx xxxx xxxx 1234" [message #130219]

Thu, 28 July 2005 19:05

sshan
Messages: 19
Registered: March 2005

Junior Member

Can anyone provide a function,which can mask the credit card number with "xxxx xxxx xxxx 1234".

Form 6i, oracle db 9i, application 11.5

Thanks in advance.

Report message to a moderator

Re: mask credit card number with "xxxx xxxx xxxx 1234" [message #130228 is a reply to message #130219]

Thu, 28 July 2005 19:36

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Go to http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements4a.htm#34563 and have a look at the format masks. You may be able to define this fixed format field directly with a mask.

(Update) Okay a single format mask won't do it.

Use four 4 byte number fields. Display them next to each other, make them fixed format, and make them 'auto skip'. On the last field, in the When-Validate-Item', populate your 19 character database field by concantenating the four number field with spaces to give you the format you need.

David

[Updated on: Fri, 29 July 2005 02:07]

Report message to a moderator

Previous Topic:	INFO NEEDED
Next Topic:	System current_datetime (merged threads)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 12:04:51 CDT 2024