Home » Developer & Programmer » Forms » Function that can tell is the given STRING is a set of CHARACTER or NUMBER?
icon5.gif  Function that can tell is the given STRING is a set of CHARACTER or NUMBER? [message #255261] Tue, 31 July 2007 04:05 Go to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
I was just woundering is there any PL-Sql function that can tell by analyzing a STRING weather it is a set of CHARACTER or NUMBER
Re: Function that can tell is the given STRING is a set of CHARACTER or NUMBER? [message #255265 is a reply to message #255261] Tue, 31 July 2007 04:26 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I know, there are no such functions in Oracle. Check list of available functions.

In order to be able to check what you need, you'll have to write your own functions; or, search the Internet for (for example) IS_CHAR and IS_NUMBER - you might run into working ones.

[Updated on: Tue, 31 July 2007 04:27]

Report message to a moderator

Re: Function that can tell is the given STRING is a set of CHARACTER or NUMBER? [message #256050 is a reply to message #255261] Thu, 02 August 2007 20:28 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Look at http://www.orafaq.com/forum/m/168856/67467/?srch=rtrim+david#msg_168856 and http://www.orafaq.com/forum/m/173919/67467/?srch=rtrim#msg_173919

David
Previous Topic: Forms 6i and Oracle 10g R2
Next Topic: frm - 40202
Goto Forum:
  


Current Time: Fri Dec 02 18:33:48 CST 2016

Total time taken to generate the page: 0.46732 seconds