The CUSTOMERS table has a CUST_LAST NAME column of data type VARCHAR2
The table has two rows whose CUST_LAST NAME values are Anderson and Ausson
Which query produces output for CUST_LAST NAME containing oder for the first row and Aus
For the
Second?
A.SELECT REPLACE(SUBSTR(cust_last_name, -3),'AN', "O')FROM customers;
B.SELECT INITCAPREPLACE(TRIM('SON FROM cust_last_namE.,'AN,'O'))FROM
Customers;
C.SELECT REPLACE(TRIM(TRAILING "SON' FROM cust last namE.,'AN, 'O') FROM
Customers
D.SELECT REPLACE(REPLACE(cust last name, ' son', '),'AN', 'O')FROM customers;
正确答案D