Manipulating strings
The company has launched a platform for customers. You've been asked to generate a username that's easy for customers to remember and for employees to interpret. You decide a username should be composed of these characters in lowercase and in the following order:
- First four letters of
LastName
- All characters of the
CustomerId
This exercise is part of the course
Introduction to Oracle SQL
Exercise instructions
- Output a new column called
Username
using the concatenation function. - Get the necessary letters from
LastName
using the substring function. - Add the
CustomerId
toLastName
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Output a new column called Username
SELECT LastName, CustomerId, ___(
-- First four letters of LastName
___,
-- CustomerId
___
) AS ___
FROM ___