没有合适的资源?快使用搜索试试~ 我知道了~
首页SAP-HANA数据库SQL参考手册.pdf(中文版)
资源详情
资源评论
资源推荐
SAP HANA Database - SQL ৲㘳
S
AP HANA Appliance Software SPS 04
ⴞḷ䈫㘵
亮䰞
㇑⨶ઈ
SAP⺜ԦՉդ
ަԆ
目录
符号表示 .............................................................................................................................................. 12
引言 ...................................................................................................................................................... 13
SQL ................................................................................................................................................ 13
支持的语言和代码页.................................................................................................................... 13
注释 .............................................................................................................................................. 13
标识符 .......................................................................................................................................... 13
单引号 .......................................................................................................................................... 14
双引号 .......................................................................................................................................... 14
SQL 保留字.................................................................................................................................... 14
数据类型 .............................................................................................................................................. 16
数据类型的分类 ........................................................................................................................... 16
日期时间类型 ............................................................................................................................... 16
Date 格式 .............................................................................................................................. 16
Time 格式 .............................................................................................................................. 17
Timestamp 格式 .................................................................................................................... 18
日期/时间类型支持的函数: ............................................................................................... 19
数字类型 ....................................................................................................................................... 20
字符类型 ....................................................................................................................................... 21
二进制类型 ................................................................................................................................... 22
大对象(LOB)类型 ..................................................................................................................... 22
SQL 数据类型和列存储数据类型之间的映射 .............................................................................. 23
数据类型转换 ............................................................................................................................... 24
类型常量 ....................................................................................................................................... 27
谓词 ...................................................................................................................................................... 29
SAP HANA 数据库– SQL 参考手册
2
比较谓词 ....................................................................................................................................... 29
范围谓词 ....................................................................................................................................... 29
In 谓词 .......................................................................................................................................... 29
Exists 谓词 ..................................................................................................................................... 29
NULL 谓词 ..................................................................................................................................... 30
CONTAINS 谓词 ............................................................................................................................. 30
操作符 .................................................................................................................................................. 33
一元和二元操作符 ....................................................................................................................... 33
操作符优先级 ............................................................................................................................... 33
算术操作符 ................................................................................................................................... 34
字符串操作符 ............................................................................................................................... 34
比较操作符 ................................................................................................................................... 35
逻辑操作符 ................................................................................................................................... 35
集合操作符 ................................................................................................................................... 35
表达式 .................................................................................................................................................. 36
Case 表达式 .................................................................................................................................. 36
Function 表达式 ............................................................................................................................ 36
Aggregate 表达式 .......................................................................................................................... 37
表达式中的子查询 ....................................................................................................................... 37
SQL 函数 ............................................................................................................................................... 39
介绍 .............................................................................................................................................. 39
数据类型转换函数 ....................................................................................................................... 39
CAST ...................................................................................................................................... 39
TO_ALPHANUM ..................................................................................................................... 39
TO_BIGINT ............................................................................................................................. 40
SAP HANA 数据库– SQL 参考手册
3
TO_BINARY ............................................................................................................................ 40
TO_BLOB ................................................................................................................................ 40
TO_CHAR ............................................................................................................................... 41
TO_CLOB ................................................................................................................................ 41
TO_DATE ................................................................................................................................ 41
TO_DATS ................................................................................................................................ 42
TO_DECIMAL .......................................................................................................................... 42
TO_DOUBLE ........................................................................................................................... 43
TO_INT ................................................................................................................................... 43
TO_INTEGER........................................................................................................................... 43
TO_NCHAR ............................................................................................................................. 44
TO_NCLOB ............................................................................................................................. 44
TO_NVARCHAR ...................................................................................................................... 44
TO_REAL ................................................................................................................................ 45
TO_SECONDDATE ................................................................................................................... 45
TO_SMALLDECIMAL ............................................................................................................... 45
TO_SMALLINT ........................................................................................................................ 46
TO_TIME ................................................................................................................................ 46
TO_TIMESTAMP ..................................................................................................................... 46
TO_TINYINT............................................................................................................................ 47
TO_VARCHAR ......................................................................................................................... 47
日期时间函数 ............................................................................................................................... 47
ADD_DAYS ............................................................................................................................. 47
ADD_MONTHS ....................................................................................................................... 48
ADD_SECONDS ....................................................................................................................... 48
SAP HANA 数据库– SQL 参考手册
4
ADD_YEARS ............................................................................................................................ 48
CURRENT_DATE ..................................................................................................................... 49
CURRENT_TIME ...................................................................................................................... 49
CURRENT_TIMESTAMP........................................................................................................... 49
CURRECT_UTCDATE ............................................................................................................... 50
CURRENT_UTCTIME ............................................................................................................... 50
CURRENT_UTCTIMESTAMP .................................................................................................... 50
DAYNAME .............................................................................................................................. 51
DAYOFMONTH ....................................................................................................................... 51
DAYOFYEAR............................................................................................................................ 51
DAYS_BETWEEN ..................................................................................................................... 52
EXTRACT ................................................................................................................................ 52
HOUR ..................................................................................................................................... 52
ISOWEEK ................................................................................................................................ 53
LAST_DAY............................................................................................................................... 53
LOCALTOUTC.......................................................................................................................... 53
MINUTE ................................................................................................................................. 54
MONTH .................................................................................................................................. 54
MONTHNAME ........................................................................................................................ 54
NEXT_DAY .............................................................................................................................. 55
NOW ...................................................................................................................................... 55
QUARTER ............................................................................................................................... 55
SECOND ................................................................................................................................. 56
SECONDS_BETWEEN .............................................................................................................. 56
UTCTOLOCAL.......................................................................................................................... 56
剩余227页未读,继续阅读
qq_527235890
- 粉丝: 8
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- RTL8188FU-Linux-v5.7.4.2-36687.20200602.tar(20765).gz
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
- SPC统计方法基础知识.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论12