OraFAQ Forum: Forms » how to enter phone no starting with 0..

Home » Developer & Programmer » Forms » how to enter phone no starting with 0..

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

how to enter phone no starting with 0.. [message #309959]

Sun, 30 March 2008 13:11

sagar002100
Messages: 12
Registered: March 2008

Junior Member

hi,,
i want to enter phone number with city code (e.g.079-123456), which generally has 0 at the start..and my field type is number..so how to save the phone number starting with 0..????

Report message to a moderator

Re: how to enter phone no starting with 0.. [message #309960 is a reply to message #309959]

Sun, 30 March 2008 13:28

varu123
Messages: 754
Registered: October 2007

Senior Member

Quote:

e.g.079-123456

This is not a number.You can not use number to store alplanumeric values.
Change the datatype to varchar2

[Updated on: Sun, 30 March 2008 13:33]

Report message to a moderator

Re: how to enter phone no starting with 0.. [message #309961 is a reply to message #309960]

Sun, 30 March 2008 13:38

sagar002100
Messages: 12
Registered: March 2008

Junior Member

i tried it..bt it didnt work..Actually i wann to enter 079135645 not 079-125645...

Report message to a moderator

Re: how to enter phone no starting with 0.. [message #309963 is a reply to message #309959]

Sun, 30 March 2008 13:42

varu123
Messages: 754
Registered: October 2007

Senior Member

What did you try?

If your datatype is number,use to_char function when inserting rows.

Report message to a moderator

Re: how to enter phone no starting with 0.. [message #309964 is a reply to message #309963]

Sun, 30 March 2008 13:45

sagar002100
Messages: 12
Registered: March 2008

Junior Member

thankxxxxxxxx

Report message to a moderator

Re: how to enter phone no starting with 0.. [message #309971 is a reply to message #309963]

Sun, 30 March 2008 16:05

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

varu123 wrote on Sun, 30 March 2008 20:42

If your datatype is number,use to_char function when inserting rows.

I'm not sure I understood this; what good would that do? If a column is of a NUMBER datatype, there's no function (that I know of) which will allow anyone to insert value with a leading zero.

In other words: if you want to store a value with a leading zero, you'll have to use CHARACTER column datatype (as suggested in the second message).

The answer was

sagar002100

i tried it..bt it didnt work

Sorry, but I don't believe you. Can you prove it?

Report message to a moderator

Re: how to enter phone no starting with 0.. [message #310018 is a reply to message #309959]

Mon, 31 March 2008 00:03

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Dear Friends,

who said that you cann't you this "079-123456" as number. See FORMAT MASK property and you will find your solution.

Regards,
Azam Khan

Report message to a moderator

Re: how to enter phone no starting with 0.. [message #310278 is a reply to message #310018]

Mon, 31 March 2008 16:46

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Sure. Do that and, after committing changes, please, copy and paste SQL*Plus session in which you SELECT value you've just stored through a form. I'd really love to see a NUMBER datatype column with a leading zero.

Report message to a moderator

Previous Topic:	How to run a SQL-statement in Forms
Next Topic:	Problem in loop to search values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 10:24:22 CDT 2024