Answer to Question #309949 in Databases | SQL | Oracle | MS Access for Simu

Question

Create a PL/SQL block that will prompt the user to enter a staff number .Your block then has to retrieve and display the surname, telephone number, appointment date, and monthly salary and set up a new password for this staff member. Derive this new password by joining the current password with the last 4 numbers of the staff’s telephone number. Make use of the correct padding function to include the stars in the password.

Enter value for employee_number: 1 Employee DLAMINI ZUMA Date employed 1st of January 2014 Monthly Salary $12,000.00 New Password DZTP#001**4554

PL/SQL procedure successfully completed.

SQL> /

Enter value for employee_number: 2 Employee MAHLANGU Date employed 1st of January 2014 Monthly Salary $10,000.00 New Password MJ#002**4532

PL/SQL procedure successfully completed.

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order