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..????
|
|
|
|
|
|
|
|
|
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: 21823 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.
|
|
|