SQL Qusetion Error
I have this question in oracle certificate document and they give the solution with it included so the question is
Evaluate the SQL Statement :
Select LPAD (salary,10,*) from emp where emp_id=1001;
If the employee with the EMP_ID 1001 has a salary of 17000 , what is displayed ?
A.17000.00
B.17000*****
C.****170.00
D.**17000.00
E. an error statement
And they give the solution is C
But I think it is ERROR because it should be the E because * should have ‘*’ ,because it is Oracle certificate question and if i do this add with the query ( and salary = 17000 ) its will give nothing are u agree with me?