Oracle Expression Lists

表达式列表是其他表达式的组合,常用于SQL查询和子查询的条件和成员资格判断。每个表达式集由括号包围,且每个集的表达式数量必须相同,匹配条件中的表达式数。列表最多包含1000个表达式,而表达式集的数量不受限制,但每个集最多1000个。有效的表达式列表示例包括在不同SQL子句中的应用,如GROUP BY。
摘要由CSDN通过智能技术生成

An expression list is a combination of other expressions.

 

Expression lists can appear in comparison and membership conditions and in GROUP BY clauses of queries and subqueries.

Comparison and membership conditions appear in the conditions of WHERE clauses. They can contain either one or more comma-delimited expressions, or one or more sets of expressions where each set contains one or more comma-delimited expressions. In the latter case (multiple sets of expressions):

  • Each set is bounded by parentheses
  • Each set must contain the same number of expressions
  • The number of expressions in each set must match the number of expressions before the operator in the comparison condition or before the IN
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值