|
|
|
Re: Query need [message #321190 is a reply to message #321171] |
Mon, 19 May 2008 06:41 |
skooman
Messages: 913 Registered: March 2005 Location: Netherlands
|
Senior Member |
|
|
Or, if you don't want to use PL/SQL, just SQL do something like:
SELECT CASE
WHEN length(translate('abc123'
,'x1234567890.,'
,'x')) IS NULL THEN
'yes'
ELSE
'no'
END is_number
FROM dual
|
|
|
|
Re: Query need [message #321214 is a reply to message #321193] |
Mon, 19 May 2008 08:03 |
skooman
Messages: 913 Registered: March 2005 Location: Netherlands
|
Senior Member |
|
|
Oops...
Have to admit that the code was from a situation where no dots or commas were involved, I just added them on the fly. Stupid me...
Well, if you want just SQL and no dots and commas are involved, it works!
|
|
|