Home » SQL & PL/SQL » SQL & PL/SQL » validation check for numeric and alphabets (Oracle 9i)
validation check for numeric and alphabets [message #323237] Tue, 27 May 2008 19:16 Go to next message
babuanna
Messages: 28
Registered: October 2007
Junior Member
Hi,

In oracle, how can I check for alphanumeric characters?

please help!!

Thanks in advance.
Re: validation check for numeric and alphabets [message #323240 is a reply to message #323237] Tue, 27 May 2008 20:45 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>how can I check for alphanumeric characters?

Write a function that meets your requirements.
Re: validation check for numeric and alphabets [message #323253 is a reply to message #323237] Tue, 27 May 2008 22:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is precisely your need?

Regards
Michel
Re: validation check for numeric and alphabets. [message #323259 is a reply to message #323237] Tue, 27 May 2008 23:40 Go to previous messageGo to next message
babuanna
Messages: 28
Registered: October 2007
Junior Member
Hi,

I need to validate a string input from a user.

Hence, I need to check that the string does not contain alphanumeric characters. If it does, then it throws an exception.

Is there an oracle standard function that can retrieve this info? or Any ideas?



Thanks in advance.
Re: validation check for numeric and alphabets [message #323260 is a reply to message #323237] Tue, 27 May 2008 23:42 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>Any ideas?
Write a function that meets your requirements.
Re: validation check for numeric and alphabets. [message #323266 is a reply to message #323259] Wed, 28 May 2008 00:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I need to check that the string does not contain alphanumeric characters.

The field must not contain an alphanumeric character! Which kind of field is this?

Regards
Michel
Re: validation check for numeric and alphabets [message #323576 is a reply to message #323237] Wed, 28 May 2008 21:58 Go to previous messageGo to next message
babuanna
Messages: 28
Registered: October 2007
Junior Member
Hi,

I have a field on a form which can take input from the user. This field needs to be validated if the user enters in non-alphanumeric characters.

In other words, I need to check for non_aplhanumeric chars.

Thanks in advance.
Re: validation check for numeric and alphabets [message #323601 is a reply to message #323576] Thu, 29 May 2008 00:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
In other words, I need to check for non_aplhanumeric chars.

This absolutly not the same thing than:
Quote:
I need to check that the string does not contain alphanumeric characters.

Clear your mind and say us what do you want in the end.

Regards
Michel
Re: validation check for numeric and alphabets [message #323606 is a reply to message #323237] Thu, 29 May 2008 00:15 Go to previous messageGo to next message
babuanna
Messages: 28
Registered: October 2007
Junior Member
Hi All,

Alright, it wasn't a very difficult question to understand, anyway i will post it again.


My question is this:

I have a field on a form which can take input from the user. This field needs to be validated if the user enters in non-alphanumeric characters.

In other words, I need to check for non_aplhanumeric chars.


Anacedent, if you please know the answers, can you please post it? Can you please let us know the function itself?

Thanks in advance.
Re: validation check for numeric and alphabets [message #323614 is a reply to message #323606] Thu, 29 May 2008 00:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
it wasn't a very difficult question to understand.

But you seem to have difficulties to write it. My previous post contain 2 of your posts that are inconsistent.

Now, it is easy to do it with TRANSLATE and if you search this has been answered many times and not ealier than this week.

Regards
Michel
Re: validation check for numeric and alphabets [message #323618 is a reply to message #323237] Thu, 29 May 2008 00:43 Go to previous messageGo to next message
babuanna
Messages: 28
Registered: October 2007
Junior Member
Hi,

I did do a search for translate and it gave many options.

It also did not work for one of the situations.

If you can please post me the sql or the function that is used, that would be appreciated.

Thanks in advance.
Re: validation check for numeric and alphabets [message #323624 is a reply to message #323618] Thu, 29 May 2008 00:59 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
It also did not work for one of the situations.

Which one?

Post what you tried.

Regards
Michel
Previous Topic: unload BLOB to os file (plsql)
Next Topic: Problem in converting Month to month numbers?
Goto Forum:
  


Current Time: Tue Dec 06 10:07:42 CST 2016

Total time taken to generate the page: 0.11049 seconds