×
多选题
下面是CUSTOMERS表CUST_NAME列的数据:
下面是CUSTOMERS表CUST_NAME列的数据:
CUST_NAME
Lex De Haan
Renske Ladwig
Jose Manuel Urman
Jason Mallin
现在要提取那些有三个名字的客户，第一个名字用*号替换，比如下面这两个:
CUST NAME
*** De Haan
**** Manuel Urman
在Oracle环境下，哪两个查询能得出想要的结果？
A
SELECTLPAD(SUBSTR(cust_name,INSTR(cust_name,＇＇)),LENGTH(cust_name),＇*＇)"CUSTNAME"FROMcustomersWHEREINSTR(cust_name,＇＇,1,2)<>0;
B
SELECTLPAD(SUBSTR(cust_name,INSTR(cust_name,＇＇)),LENGTH(cust_name),＇*＇)"CUSTNAME"FROMcustomersWHEREINSTR(cust_name,＇＇,-1,2)<>0;
C
SELECTLPAD(SUBSTR(cust_name,INSTR(cust_name,＇＇)),LENGTH(cust_name)-INSTR(cust_name,＇＇),＇*＇)"CUSTNAME"FROMcustomersWHEREINSTR(cust_name,＇＇,-1,-2)<>0;
D
SELECTLPAD(SUBSTR(cust_name,INSTR(cust_name,＇＇)),LENGTH(cust_name)-INSTR(cust_name,＇＇),＇*＇)"CUSTNAME"FROMcustomersWHEREINSTR(cust_name,＇＇,1,2)<>0;
答案解析
正确答案：AB
题目纠错
