Write a SELECT statement that uses regular expression functions to get the username and domain name parts
Fantastic news! We've Found the answer you've been seeking!
Question:
Write a SELECT statement that uses regular expression functions to get the username and domain name parts of the email addresses in the Administrators table. Return these columns: The email_address column A column named user_name that contains the username part of the email_address column (the part before the @ symbol) A column named domain_name that contains the domain name part of the email_address column (the part after the @ symbol)
Related Book For
Posted Date: