looking for a way to define a FORMAT_MASK of varchar2 in a special way
455866Oct 3 2005 — edited Oct 6 2005Hi,
Does anyone know how to do a format mask where it takes a value from one table and forces a conversion of another value to match the same pattern the first value has? (without using piping to show symbols like - or simular stuff)
I'm trying to have something be set up so that when a user enters a phone number on forms it will auto convert it to the pre-defined format given ahead of time. I'll be doing this when a new value is added (assumed to be when_new_record_instance) and when it is changed (assuming that validation will be a good time for that so going with when_validate_item)
Though this is a forms issue, I'd like to go the SQL trigger route as opposed to making changes in property palette...
Any help would be appreciated