PL/SQL: How to check that parameter is case-sensitive?

610 pts.
Tags:
PL/SQL
PL/SQL block
PL/SQL error messages
REGEXP
Regular expressions
Hi Experts how can i check the email id shud take only lower case in PL/SQL block i tried using vpos := REGEXP_LIKE(p_email_address,'[:lower:]','C'); as well vpos ;= REGEXP_LIKE(p_email_address,'[^[:lower:]]','C') But both says wrong type as error and p_email_address is a parameter of procedure and i declared vpos as varchar2 please help me!!!!

Answer Wiki

Thanks. We'll let you know when a new response is added.

How about this ?

<pre> if lower(p_email_address) != p_email_address then
dbms_output.put_line(‘wrong’);
else
dbms_output.put_line(‘right’);
end if;</pre>

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Inprise
    thanks it answered my question
    610 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: