#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhat query should be used in order to display the salary leftpadded with 15 character long and =E2=80=98$' as special character and another column salary right padded with 10 character long with =E2=80=98@' as special character used of all employees in 201, 176 and 144.

Answer

SELECT LPAD(SALARY,15,'$'), RPAD(SALARY,10,'@')FROM EMPLOYEESWHERE EMPLOYEE_ID IN (201,176,144);