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!!!!
December 12, 2008 4:18 AM
December 18, 2008 9:00 AM