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!!!!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: