MulaiMulai sekarang secara gratis

Replacing letters

Now that you've got the usernames, you need temporary passwords to give customers! They will be asked to change it after their first login, but you need to give them a temporary password that is not too difficult to remember and is customized to them. You decide a temporary password should be made up of a customer's LastName. To make it more secures, as should be replaced with @, ss with $, and e with 3.

To do this, you'll have to use the REPLACE() function shown in the video. Its documentation is available here.

Latihan ini adalah bagian dari kursus

Introduction to Oracle SQL

Lihat Kursus

Latihan interaktif praktis

Cobalah latihan ini dengan menyelesaikan kode contoh berikut.

SELECT 
	-- Replace a with @
	___(___, ___, ___)
FROM ___
Edit dan Jalankan Kode