Home » Developer & Programmer » Application Express & MOD_PLSQL » Number Format (Oracle 11g,XP)
Number Format [message #613344] Mon, 05 May 2014 05:00 Go to next message
Xandot
Messages: 107
Registered: January 2014
Location: India
Senior Member
Hi Experts,

Please Help Me out ...

I have one numeric field and i want to enter the value like "11.12.3.40" ,So how can i do this ..


Thanks
Re: Number Format [message #613346 is a reply to message #613344] Mon, 05 May 2014 05:01 Go to previous messageGo to next message
Littlefoot
Messages: 19651
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, you can not. This is not a valid number. You'll have to modify column's data type to VARCHAR2.
Re: Number Format [message #613347 is a reply to message #613346] Mon, 05 May 2014 05:05 Go to previous messageGo to next message
Xandot
Messages: 107
Registered: January 2014
Location: India
Senior Member
Thanks for reply littlefoot..

Is there any format type for the same in varchar2 field...
Re: Number Format [message #613348 is a reply to message #613347] Mon, 05 May 2014 05:09 Go to previous messageGo to next message
Littlefoot
Messages: 19651
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No, but you could create a check constraint which would take care about the correct data format. Regular expressions might be handy in this case (you'd use REGEXP_LIKE with the appropriate format mask).
Re: Number Format [message #613349 is a reply to message #613348] Mon, 05 May 2014 05:23 Go to previous message
Xandot
Messages: 107
Registered: January 2014
Location: India
Senior Member
Ok thanks Littlefoot i got the point..
Previous Topic: Creating APEX users/groups
Next Topic: Hide Buttons On Region
Goto Forum:
  


Current Time: Thu Oct 02 01:29:23 CDT 2014

Total time taken to generate the page: 0.06803 seconds