<{p}>143、<{br/}>choose the best answer<{br/}>The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2.<{br/}>The table has two rows whose CUST_LAST_MANE values are Anderson and Ausson.<{br/}>Which query produces output for CUST_LAST_SAME containing Oder for the first row<{br/}>and Aus for the second?<{br/}><{/p}>

发布于 2021-02-18 21:25:30
【多选题】
A <{p}>SELECT REPLACE (REPLACE(cust_last_name,'son',''),'An','O') FROM customers;<{br/}><{/p}>
B <{p}>SELECT REPLACE (TRIM(TRALING 'son' FROM cust_last_name), 'An','O') FROM<{br/}>customers;<{br/}><{/p}>
C <{p}>SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name),'An','O')) FROM<{br/}>customers;<{br/}><{/p}>
D <{p}>SELECT REPLACE (SUBSTR(cust_last_name,-3), 'An', 'O') FROM customers;<{br/}><{/p}>

查看更多

关注者
0
被浏览
83
  • 体验AI问答!更聪明、超智能!
  • 一款基于GPT的超级AI助手,可以对话、创作、写文案!
1 个回答

撰写答案

请登录后再发布答案,点击登录

发布
问题

手机
浏览

扫码手机浏览

分享
好友

在线
客服