OCP-047 USING ORA-25154: USING 子句的列部分不能有限定词

最新推荐文章于 2023-08-21 17:30:42 发布

xiadingling

最新推荐文章于 2023-08-21 17:30:42 发布

阅读量3.4k

点赞数

分类专栏： OCP 文章标签： join date structure table sql

本文链接：https://blog.csdn.net/xiadingling/article/details/7859163

版权

OCP 专栏收录该内容

72 篇文章

订阅专栏

当尝试使用JOIN子句结合USING(order_id)从orders和order_items表中选择数据时，会遇到ORA-25154错误，提示USING子句的列部分不能有限定词。尝试的不同SELECT语句都导致了相同的错误，即使在SELECT列表中省略表别名或完全省略别名。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

34. View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS
tables. Evaluate the following SQL statement:
SELECT oi.order_id, product_id, order_date
FROM order_items oi JOIN orders o USING(order_id).
Which statement is true regarding the execution of this SQL statement?
A. The statement would not execute because table aliases are not allowed in
the JOIN clause.
B. The statement would not execute because the table alias prefix is not used
in the USING clause.
C. The statement would not execute because all the columns in the SELECT
clause are not prefixed with table aliases.
D. The statement would not execute because the column part of the USING clause
cannot have a qualifier in the SELECT list.
Answer: D

SQL> SELECT oi.order_id, o.product_id, order_date
2 FROM orders oi JOIN order_items o USING(order_id);

SELECT oi.order_id, o.product_id, order_date
FROM orders oi JOIN order_items o USING(order_id)

ORA-25154: USING 子句的列部分不能有限定词

SQL>
SQL> SELECT o.order_id, o.product_id, order_date
2 FROM orders oi
3 JOIN order_items o
4 USING (order_id);

SELECT o.order_id, o.product_id, order_date
FROM orders oi
JOIN order_items o
USING (order_id)

ORA-25154: USING 子句的列部分不能有限定词

SQL>
SQL> SELECT order_id, o.product_id, order_date
2 FROM orders oi
3 JOIN order_items o
4 USING (order_id);

ORDER_ID PRODUCT_ID ORDER_DATE
---------- ---------- --------------------------------------------------------------------------------
100 1
101 2
102 4
103 5