【ocp-12c】最新Oracle OCP-071考试题库（46题）

Examine the data in the CUST_NAME column of the CUSTOMERS table.

CUST_NAME

Lex De Haan

Renske Ladwig

Jose Manuel Urman

Jason Mallin

You want to extract only those customer names that have three names and display the * symbol in

place of the first name as follows:

CUST_NAME

*** De Haan

**** Manuel Urman

Which two queries give the required output?

A) SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,‘ ‘)),LENGTH(cust_name),‘*‘) "CUST NAME" FROM customers

WHERE INSTR(cust_name,‘ ‘,1,2)<>0;

B) SELECT LPAD(SUBSTR(cust_name,LENGTH(cust_name)- INSTR(cust_name,‘ ‘),‘*‘) "CUST NAME"

FROM customers

WHERE INSTR(cust_name,2)<>0 ;

C) SELECT LPAD(SUBSTR(cust_name,-1,2)<>0;

D) SELECT LPAD(SUBSTR(cust_name,-2)<>0;

Answer：AC

(解析：题意是：您希望只提取具有三个名称的那些客户名称，并显示*符号来代替名称如下注意条件的用法 INSTR(cust_name,2)<>00，意思是从名字中找空格，从第一个开始，查看第二个空格的位置，如果有，说明名字里面就有三个名称，否则只有两个名称。同时INSTR(cust_name,-2)，从倒数第一个空格开始，不能再用-2 了，要用正数)

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!