Oracle Greatest()函数
Oracle 函数
2023-09-14 09:03:18 时间
The GREATEST function returns the largest expression in a list of expressions. All expressions after the first
are implicitly converted to the data type of the first expression bef
The GREATEST function returns the largest expression in a list of expressions. All expressions after the first are implicitly converted to the data type of the first expression before the comparison. To retrieve the smallest expression in a list of expressions, use LEAST. Return Value The data type of the first expression. Syntax GREATEST (expr [, expr]...) Arguments
Example 16-3 Finding the Longest Text Expressions
Example 16-4 Finding the Largest Numerical Expression
The GREATEST function returns the largest expression in a list of expressions. All expressions after the first are implicitly converted to the data type of the first expression before the comparison. To retrieve the smallest expression in a list of expressions, use LEAST. Return Value The data type of the first expression. Syntax GREATEST (expr [, expr]...) Arguments
An expression.
Example 16-3 Finding the Longest Text Expressions
The following statement selects the longest string.
SHOW GREATEST (Harry, Harriot, Harold) Harriot
Example 16-4 Finding the Largest Numerical Expression
The following statement selects the number with the greatest value.
SHOW GREATEST (5, 3, 18) 18
原文地址:点击打开链接
相关文章
- ORACLE控制处理函数COALESCE()和NVL()
- oracle数据库添加用户至dba_oracle取消用户dba权限
- ORA-55468: rule base “string” does not exist or is not accessible ORACLE 报错 故障修复 远程处理
- ORA-01352: tablespace given for Logminer spill does not exist ORACLE 报错 故障修复 远程处理
- Oracle 时间戳去掉时分秒(oracle去掉时分秒)
- 快速复制 Oracle 数据库表(oracle复制一张表)
- 探索 Oracle 路径:一次成功的获取之旅(获取oracle路径)
- Oracle用户:遭遇被锁定困境(oracle用户被锁定)
- 来自Oracle的力量:序列的用武之地(oracle序列的作用)
- Oracle数据库出现锁表的原因分析(oracle锁表原因)
- 使用Oracle实现动态时间判断(oracle写时间判断)
- Oracle 主备环境自动切换实现稳健性(oracle主备自动切换)
- 利用Oracle快捷键轻松操作(oracle使用快捷键)
- 探索Oracle数据库中文编码的奥秘(oracle中文编码查看)
- 利用Oracle中的Top函数优化查询效率(oracle中top函数)
- Oracle中XML数据的读取研究(oracle xml读取)
- Oracle MRP材料需求计划的绝佳解决方案(oracle mrp全称)
- Oracle 8CPU 助力数据处理更迅速(oracle 8cpu)