首页 071 正文

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?

2020.2.1 071 67

(客户表具有数据类型为varchar2的CUST_LAST_NAME列。该表具有两行,其CUST_LAST_NAME值为Anderson和Ausson。哪个查询为CUST_LAST_NAME生成输出,第一行包含Oder,第二行包含Aus?)

A SELECT REPLACE (REPLACE (CUST_LAST_NAME, ‘SON’ , ‘ ‘), ‘AN’ , ‘O’) FORM CUSTOMERS

B SELECT REPLACE (TRIM (TRAILING ‘son’ FROM GUST LAST NAME), ‘AN’,’O’) FORM CUSTOMERS

C SELECT INITCAP (REPLACE (TRIM (‘SON’ FROM GUST LAST NAME), ‘AN’,’O’)) FORM CUSTOMERS

D SELECT REPLACE (SUBSTR (GUST LAST NAME,-3),’AN’,’O’)) FORM CUSTOMERS

答案:A

相关推荐:

评论

昵称*

邮箱*

网址