BaşlayınÜcretsiz Başlayın

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

Bu egzersiz

Introduction to Oracle SQL

kursunun bir parçasıdır
Kursu Görüntüle

Egzersiz talimatları

  • Output a new column called Username using the concatenation function.
  • Get the necessary letters from LastName using the substring function.
  • Add the CustomerId to LastName.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

-- Output a new column called Username
SELECT LastName, CustomerId, ___(
    -- First four letters of LastName
    ___, 
  	-- CustomerId
    ___
    ) AS ___
FROM ___
Kodu Düzenle ve Çalıştır