OraFAQ Forum: Application Express, ORDS & MOD

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Number Format (Oracle 11g,XP)

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

Number Format [message #613344]

Mon, 05 May 2014 05:00

Xandot
Messages: 235
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

Report message to a moderator

Re: Number Format [message #613346 is a reply to message #613344]

Mon, 05 May 2014 05:01

Littlefoot
Messages: 21761
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.

Report message to a moderator

Re: Number Format [message #613347 is a reply to message #613346]

Mon, 05 May 2014 05:05

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

Thanks for reply littlefoot..

Is there any format type for the same in varchar2 field...

Report message to a moderator

Re: Number Format [message #613348 is a reply to message #613347]

Mon, 05 May 2014 05:09

Littlefoot
Messages: 21761
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).

Report message to a moderator

Re: Number Format [message #613349 is a reply to message #613348]

Mon, 05 May 2014 05:23

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

Ok thanks Littlefoot i got the point..

Report message to a moderator

Previous Topic:	Creating APEX users/groups
Next Topic:	Hide Buttons On Region

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 01 02:23:24 CDT 2023