没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
SAP HANA Database - SQL
□□□□
SAP HANA Appliance Software SPS 04
□□□□
□□
□□□
S
A
P
□Ө□□□□
□Ǘ
目录
符号表示...................................................................................................................... 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
比较谓词............................................................................................................... 29
范围谓词............................................................................................................... 29
In 谓词.................................................................................................................. 29
Exists 谓词.............................................................................................................. 29
NULL 谓词.............................................................................................................. 30
CONTAINS 谓词....................................................................................................... 30
操作符......................................................................................................................... 33
一元和二元操作符................................................................................................... 33
操作符优先级......................................................................................................... 33
算术操作符............................................................................................................ 34
字符串操作符......................................................................................................... 34
比较操作符............................................................................................................ 35
逻辑操作符............................................................................................................ 35
集合操作符............................................................................................................ 35
表达式......................................................................................................................... 36
Case 表达式............................................................................................................ 36
Func'on 表达式...................................................................................................... 36
Aggregate 表达式..................................................................................................... 37
表达式中的子查询................................................................................................... 37
SQL 函数...................................................................................................................... 39
介绍..................................................................................................................... 39
数据类型转换函数................................................................................................... 39
CAST...........................................................................................................................................39
TO_ALPHANUM.........................................................................................................................39
TO_BIGINT..................................................................................................................................40
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
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
WEEK..........................................................................................................................................57
WEEKDAY...................................................................................................................................57
YEAR...........................................................................................................................................57
数字函数............................................................................................................... 58
ABS.............................................................................................................................................58
ACOS..........................................................................................................................................58
ASIN...........................................................................................................................................59
ATAN..........................................................................................................................................59
ATAN2........................................................................................................................................59
BINTOHEX..................................................................................................................................60
BITAND.......................................................................................................................................60
CEIL............................................................................................................................................60
COS.............................................................................................................................................61
COSH..........................................................................................................................................61
COT............................................................................................................................................61
EXP.............................................................................................................................................62
FLOOR........................................................................................................................................62
GREATEST...................................................................................................................................62
HEXTOBIN..................................................................................................................................63
剩余63页未读,继续阅读
资源评论
- 行走的瓶子Yolo2023-07-28总的来说,这个SQL参考手册是一个不可多得的工具,无论是新手还是高级用户都会从中受益匪浅。
- 会飞的黄油2023-07-28虽然是一份技术文档,但它的排版和格式都非常清晰,使得我的阅读体验更加愉快。
- 黄涵奕2023-07-28文件中提供了丰富的示例和应用场景,让我能够将理论知识与实际操作相结合,更好地应对各种问题。
- 十二.122023-07-28这个文件对于初学者来说也非常友好,通过简洁明了的语言,让我更快地理解和掌握SQL的使用。
- 罗小熙2023-07-28这个SQL参考手册是我在工作中必备的工具之一,帮助我更快速地处理SAP-HANA数据库相关的操作。
薛定谔的猫喵喵
- 粉丝: 14
- 资源: 51
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功