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正确答案D
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;