中文版SAP-HANA数据库SQL参考手册.docx_hana数据库

HANA

SQL

5星 · 超过95%的资源需积分: 5 108 浏览量更新于2023-03-16 评论 1 收藏 1.11MB DOCX 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

SAP HANA Database - SQL

□□□□

SAP HANA Appliance Software SPS 04

□□□□

□□

□□□

□Ө□□□□

□Ǘ

符号表示...................................................................................................................... 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页未读，继续阅读

行走的瓶子Yolo

2023-07-28

总的来说，这个SQL参考手册是一个不可多得的工具，无论是新手还是高级用户都会从中受益匪浅。

薛定谔的猫喵喵

粉丝: 14
资源: 51

会员权益专享

中文版SAP-HANA数据库SQL参考手册.docx

评论5

会员权益专享

最新资源

中文版SAP-HANA数据库SQL参考手册.docx

评论5

SAPHANA数据库SQL参考手册.pdf

HANA SQL参考手册

SAP-HANA数据库SQL参考手册.pdf（中文版）

sap-hana数据库sql参考手册

sap hana数据库sql参考手册.doc

sap-hana数据库sql中文完全参考手册

tuned-profiles-sap-hana rpm

tuned-profiles-sap-hana

python使用sqlalchemy-hana 连接sap hana

Hana Studio安装包下载地址

saphana服务器操作系统说明,SAPHANA安装手册范本.doc

sap hana studio 操作手册

sap hana client用法

Saphana数据库特性

sap s4hana fico中文使用手册

使用 Fiori 和 QUnit 来测试 SAP HANA 数据库

写一段代码， 用java连接sap hana数据库，并打印出hana版本信息

SAP HANA 怎么连接 SAC

sap s4 hana 安装手册

hana数据库sql 脚本怎么贷出字段

会员权益专享

最新资源

写一段代码，用java连接sap hana数据库，并打印出hana版本信息