PL/SQL: How to check that parameter is case-sensitive?
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 Question   |  December 18, 2008  4:18 AM
PL/SQL, PL/SQL block, PL/SQL error messages, REGEXP, Regular expressions