Re: Forms 4.0 Char Format Mask

From: Chris Elvin <ce8834_at_socrates.simmag.co.uk>
Date: 14 Dec 1993 16:15:54 GMT
Message-ID: <2ekorq$d0q_at_simmag-trn.simmag.co.uk>

In article <2ekek3$7o3_at_terminator.rs.itd.umich.edu>, Liang Lin <llin_at_med.umich.edu> writes:
|>
|> As I understand, Oracle does not have character format mask for input
|> and output. So it is difficult, at least for me, to think of an easy way
|> to
|> implement data types such as phone numbers and social security numbers.
|> I think I might be able to convert them into numbers and mask them. Does
|> anyone have a better idea?
|>
|> Thanks.
|>

hows about a stored procedure which takes in a string and outputs a string the body of the code should do something like

                         format delimiter/separator
                              V

output := substr(input,1,2)||'-'||substr(input,3,7)

I think you get the idea                                                                                                                 

-- 
Christopher Elvin                            Simmons Magee plc
Senior Open Systems Consultant               One Dee Road
c.elvin_at_simmag.co.uk                         Richmond
Tel: +44 81 948 3114                         Surrey TW9 2JN
Fax: +44 81 940 8385        -- Integrating Technology with your needs --

Received on Tue Dec 14 1993 - 17:15:54 CET