OCP-1Z0-051-V9.02-159题

最新推荐文章于 2021-03-12 15:10:38 发布
原创 最新推荐文章于 2021-03-12 15:10:38 发布 · 9.2k 阅读 · 1 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
收录于
OCP11g解析

当前文章被收录于：

OCP11g解析
870 篇文章 151 人学习

OCP11g，051,052,053每题的解析

订阅专栏 查看详情
OCP-1Z0-051

当前文章被收录于：

OCP-1Z0-051
239 篇文章 0 人学习
订阅专栏 查看详情
本文探讨了Oracle数据库中使用INSERT语句时常见的错误之一：在包含子查询的INSERT语句中误用VALUES关键字。通过具体示例说明了正确的语法，并解释了为何在子查询中不需要VALUES关键字。

159. View the Exhibit and examine the structure of the CUSTOMERS table.

NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that

have the same data types and size as the corresponding columns in the CUSTOMERS table.

Evaluate the following INSERT statement:

INSERT INTO new_customers (cust_id, cust_name, cust_city)

VALUES(SELECT cust_id,cust_first_name' 'cust_last_name,cust_city    去掉

FROM customers   

WHERE cust_id > 23004);

The INSERT statement fails when executed. What could be the reason?

 

 

A. The VALUES clause cannot be used in an INSERT with a subquery. values后面不能跟子查询，或者直接不要VALUES

B. Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match.

C. The WHERE clause cannot be used in a subquery embedded in an INSERT statement.

D. The total number of columns in the NEW_CUSTOMERS table does not match the total number of

columns in the CUSTOMERS table.

Answer: A
答案解析：
即insert into后面的如果有子句，则不用values
sh@TESTDB> create table new_sustomers as select cust_id,cust_last_name,cust_city
  2  from customers where 1=0;
Table created.
sh@TESTDB> insert into new_sustomers(CUST_ID, CUST_LAST_NAME,CUST_CITY)
  2  values
  3  (select cust_id,cust_first_name||cust_last_name,cust_city  from customers where cust_id>23004)
  4  ;
(select cust_id,cust_first_name||cust_last_name,cust_city  from customers where cust_id>23004)
*
ERROR at line 3:
ORA-00936: missing expression
去掉values后正常
sh@TESTDB> insert into new_sustomers(CUST_ID, CUST_LAST_NAME,CUST_CITY)
  2  (select cust_id,cust_first_name||cust_last_name,cust_city  from customers where cust_id>23004)
  3  ;
32496 rows created.

 

1Z0-051考试笔记
wlbzy的专栏
11-16 7143
ORACLE 如何建立表外键 例：学生表student (id, name , sex )     成绩表score (id ,math )   如何创建表，要求 有主键，有约束 解:   CREATE TABLE STUDENT(ID CHAR(10), NAME VARCHAR(8),SEX CHAR(1));     ALTER TABLE STUDENT ADD CONS
oracle缺失表达式 insert,oracle ORA-00936: missing expression 报错的几种情况和解决方法...
weixin_31369469的博客
04-10 6689
ORA-00936:missing expressionCause:A required part of a clause or expression has been omitted. For example, a SELECT statement may have been entered without a list of columns or expressions or with a...
oracle ORA-00936: missing expression 报错的几种情况和解决方法
热门推荐
autumn20080101的专栏
10-20 3万+
oracle ORA-00936: missing expression 报错的几种情况和解决方法 2013-04-29 17:20:38 分类： Oracle ORA-00936: missing expression    Cause: A required part of a clause or expression has been omitted. For
OCP-1Z0-051 第159题 insert语句中使用子查询
Oracle
05-24 4757
一、原题 View the Exhibit and examine the structure of the CUSTOMERS table. NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and size as the c
ocp 1Z0-051 141-175题解析
Database、Code
12-11 7727
141. View the Exhibitand examine the structure of CUSTOMERS and GRADES tables. You need to displaynames and grades of customers who have the highest credit limit. Which two SQL statementswould accom
OCP-1Z0-051 补充题库 第29题 INSERT语句中有子查询
Oracle
06-24 3252
一、原题 View the Exhibit and examine the structure of the CUSTOMERS table. NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and size as the
OCP-1Z0-051-V9.02-115题
一抹曦阳-Oracle
09-24 7477
115. View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the following SQL statement: SQL> SELECT cust_city, COUNT(cust_last_name) FROM customers WHERE cust_credit_
OCP-1Z0-051-V9.02-39题
一抹曦阳-Oracle
10-16 1万+
39. Evaluate the following command:  CREATE TABLE employees (employee_id      NUMBER(2) PRIMARY KEY,  last_name        VARCHAR2(25) NOT NULL,  department_id    NUMBER(2)NOT NULL,  job_id
OCP-1Z0-051-V9.02-57题
一抹曦阳-Oracle
10-17 8373
57. The CUSTOMERS table has the following structure: name                     Null         Type CUST_ID    NOT NULL  NUMBER CUST_FIRST_NAME   NOT NULL  VARCHAR2(20) CUST_LAST_NAME   NOT NULL  VARC
OCP-1Z0-051-V9.02-156题
一抹曦阳-Oracle
09-25 9316
156. Evaluate the following SQL statement: SQL> SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name FROM custo
OCP-1Z0-051 第161题 insert子句中的子查询
Oracle
05-24 5223
一、原题  View the exhibit and examine the description for the SALES and CHANNELS tables. You issued the following SQL statement to insert a row in the SALES table: INSERT INTO sales VALUES   (23,  
OCP-1Z0-051-2015-29题
大米的专栏
07-01 499
View the Exhibit and examine the structure of the CUSTOMERS table. NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and size as the co
OCP-1Z0-051-V9.02-112题
一抹曦阳-Oracle
09-24 7769
112. View the Exhibit and examine the structure of the PROMOTIONS table. Evaluate the following SQL statement: SQL>SELECT promo_category, AVG(promo_cost) Avg_Cost, AVG(promo_cost)*.25 Avg_Overh
ocp标量子查询
提笔画秋风
03-12 577
标量子查询 Scalar Subquery Expressions A scalar subquery expression is a subquery that returns exactly one column value from one row. The value of the scalar subquery expression is the value of the select list item of the subquery. If the subquery returns 0 row
OCP-1Z0-051-V9.02-122题
一抹曦阳-Oracle
10-19 9609
122. View the Exhibit for the structure of the STUDENT and FACULTY tables. You need to display the faculty name followed by the number of students handled by the faculty at the base location. Exami
OCP-1Z0-051-V9.02-76题
一抹曦阳-Oracle
10-18 8346
76. You need to display the first names of all customers from the CUSTOMERS table that contain the character 'e' and have the character 'a' in the second last position. Which query would give the re
OCP-1Z0-051 第156题 集合操作中的ORDER BY 子句
Oracle
05-24 5025
一、原题 Evaluate the following SQL statement: SQL>SELECT cust_id, cust_last_name "Last Name"   FROM customers  WHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name   FROM customers
146.Evaluate the following SQL statement:
dwj19830118的专栏
03-09 1367
146.Evaluate the following SQL statement:
156.Evaluate the following SQL statement:
dwj19830118的专栏
03-15 1219
156.Evaluate the following SQL statement:
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值