77.In the CUSTOMERS table, the CUST_CITY column contains the value 'Paris' for the
来源:互联网 发布:自动随访系统 源码 编辑:程序博客网 时间:2024/06/06 03:30
77.In the CUSTOMERS table, the CUST_CITY column contains the value 'Paris' for the
CUST_FIRST_NAME 'ABIGAIL'.
Evaluate the following query:
SQL> SELECT INITCAP(cust_first_name||' '||UPPER(SUBSTR(cust_city,-LENGTH(cust_city),2)))
FROM customers WHERE cust_first_name = 'ABIGAIL';
What would be the outcome?
A.Abigail PA
B.Abigail Pa
C.Abigail IS
D.an error message
答案:B
解析:最外层INITCAP函数,它是首字母大写,排除ACD
CUST_FIRST_NAME 'ABIGAIL'.
Evaluate the following query:
SQL> SELECT INITCAP(cust_first_name||' '||UPPER(SUBSTR(cust_city,-LENGTH(cust_city),2)))
FROM customers WHERE cust_first_name = 'ABIGAIL';
What would be the outcome?
A.Abigail PA
B.Abigail Pa
C.Abigail IS
D.an error message
答案:B
解析:最外层INITCAP函数,它是首字母大写,排除ACD
0 0
- 77.In the CUSTOMERS table, the CUST_CITY column contains the value 'Paris' for the
- 82.Examine the data in the CUST_NAME column of the CUSTOMERS table.
- 83.Examine the data in the CUST_NAME column of the CUSTOMERS table.
- 58.The PART_CODE column in the SPARES table contains the following list of values:
- 79.View the Exhibit and examine the structure of the CUSTOMERS table. In the CUSTOMERS table, the CU
- 127.Examine the data in the CUSTOMERS table:
- MySQL - Entity : The value for column 'IsPrimaryKey' in table 'TableDetails' is DBNull
- An explicit value for the identity column in table 'users' can only be specified when a column list
- 15.View the Exhibit and examine the data in the CUSTOMERS table.
- 163.View the Exhibit and examine the description for the CUSTOMERS table.
- 165.View the Exhibit and examine the description for the CUSTOMERS table.
- Refreshing One Column based on the value of Another Column in ADFdi Table
- 3.You need to extract details of those products in the SALES table where the PROD_ID column contains
- Mining the Network Value of Customers
- 57.The CUSTOMERS table has the following structure:
- 125.Examine the structure of the CUSTOMERS table:
- 93.View the Exhibit and examine the structure of the CUSTOMERS table. Using the CUSTOMERS table, y o
- 101.Examine the data in the PROMO_BEGIN_DATE column of the PROMOTIONS table:
- Android系统服务详解-android学习之旅(95)
- Linux信号(signal)
- socket.io 中namespace 和 room的概念。
- ionic 隐藏action bar的返回按钮
- 性能测试(一):性能测试关心的结果
- 77.In the CUSTOMERS table, the CUST_CITY column contains the value 'Paris' for the
- Qt lupdate 和 lrealease 命令行使用方式(多语言)
- SSL协议详解
- try/catch/finally详解+示例
- eclipse tomcat maven 集成开发环境
- 【mergeSort】
- Intent获取值的时候空指针错误
- 24. Swap Nodes in Pairs
- 发布网页乱码