OraFAQ Forum: Forms » phone number format

Home » Developer & Programmer » Forms » phone number format

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

phone number format [message #574156]

Mon, 07 January 2013 08:31

jocelyne
Messages: 24
Registered: December 2012
Location: lebanon

Junior Member

how and where can i specify the phone number format
thxx

Report message to a moderator

Re: phone number format [message #574157 is a reply to message #574156]

Mon, 07 January 2013 08:34

BlackSwan
Messages: 20109
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/

Report message to a moderator

Re: phone number format [message #574158 is a reply to message #574157]

Mon, 07 January 2013 08:40

jocelyne
Messages: 24
Registered: December 2012
Location: lebanon

Junior Member

mmm i didnt find the answer for my question in the guidelines
so can you please provide me with a code sample Smile

Report message to a moderator

Re: phone number format [message #574161 is a reply to message #574158]

Mon, 07 January 2013 09:00

BlackSwan
Messages: 20109
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?

Report message to a moderator

Re: phone number format [message #574162 is a reply to message #574161]

Mon, 07 January 2013 09:05

jocelyne
Messages: 24
Registered: December 2012
Location: lebanon

Junior 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

Report message to a moderator

Re: phone number format [message #574163 is a reply to message #574162]

Mon, 07 January 2013 09:08

BlackSwan
Messages: 20109
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?

Report message to a moderator

Re: phone number format [message #574164 is a reply to message #574163]

Mon, 07 January 2013 09:15

jocelyne
Messages: 24
Registered: December 2012
Location: lebanon

Junior 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?

Report message to a moderator

Re: phone number format [message #574173 is a reply to message #574164]

Mon, 07 January 2013 10:37

Michel Cadot
Messages: 54236
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

Report message to a moderator

Re: phone number format [message #574180 is a reply to message #574164]

Mon, 07 January 2013 12:40

joy_division
Messages: 4267
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

Report message to a moderator

Previous Topic:	how to create trial version in oracle project
Next Topic:	button search

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 18:15:18 CDT 2013

Total time taken to generate the page: 0.66922 seconds