Home » Developer & Programmer » Forms » phone number format
icon5.gif  phone number format [message #574156] Mon, 07 January 2013 08:31 Go to next message
jocelyne
Messages: 34
Registered: December 2012
Location: lebanon
Member
how and where can i specify the phone number format
thxx
Re: phone number format [message #574157 is a reply to message #574156] Mon, 07 January 2013 08:34 Go to previous messageGo to next message
BlackSwan
Messages: 22839
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: phone number format [message #574158 is a reply to message #574157] Mon, 07 January 2013 08:40 Go to previous messageGo to next message
jocelyne
Messages: 34
Registered: December 2012
Location: lebanon
Member
mmm i didnt find the answer for my question in the guidelines
so can you please provide me with a code sample Smile
Re: phone number format [message #574161 is a reply to message #574158] Mon, 07 January 2013 09:00 Go to previous messageGo to next message
BlackSwan
Messages: 22839
Registered: January 2009
Senior Member
>how and where can i specify the phone number format
I don't understand the question.

what does phone number format have to do with Oracle SQL or PL/SQL?
specify to who, where & for what?
Re: phone number format [message #574162 is a reply to message #574161] Mon, 07 January 2013 09:05 Go to previous messageGo to next message
jocelyne
Messages: 34
Registered: December 2012
Location: lebanon
Member
i have an item for a phone number and i need to specify a format mask for the item. Example = (999)99-999999 and different format shouldn't be accepted

Re: phone number format [message #574163 is a reply to message #574162] Mon, 07 January 2013 09:08 Go to previous messageGo to next message
BlackSwan
Messages: 22839
Registered: January 2009
Senior Member
>i have an item for a phone number and i need to specify a format mask for the item. Example = (999)99-999999 and different format shouldn't be accepted

what does phone number format have to do with Oracle SQL or PL/SQL?
specify to who, where & for what?

Why do you not answer my questions?
Re: phone number format [message #574164 is a reply to message #574163] Mon, 07 January 2013 09:15 Go to previous messageGo to next message
jocelyne
Messages: 34
Registered: December 2012
Location: lebanon
Member
it has to do with pl/sql cz i need to write a 'when validate item ' trigger
to who? to a certain item
where? an oracle form
for what ? for validating the phone number item
did i answer your questions? or shall i make my question more clear?
Re: phone number format [message #574173 is a reply to message #574164] Mon, 07 January 2013 10:37 Go to previous messageGo to next message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Do NOT use IM/SMS speak
2/ Always post your Oracle version, with 4 decimals.
3/ With any SQL or PL/SQL question, please, Post a working Test case: create table and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Regards
Michel
Re: phone number format [message #574180 is a reply to message #574164] Mon, 07 January 2013 12:40 Go to previous message
joy_division
Messages: 4520
Registered: February 2005
Location: East Coast USA
Senior Member
jocelyne wrote on Mon, 07 January 2013 10:15

where? an oracle form


Ok then, it's a forms question. There is an item property called format mask. you do not need a trigger.

[mod-edit] moving to forms forum
Previous Topic: how to create trial version in oracle project
Next Topic: button search
Goto Forum:
  


Current Time: Tue Sep 30 16:57:43 CDT 2014

Total time taken to generate the page: 0.24082 seconds