Oracle 20C官方文档-SQL Language Reference
免费
专栏简介
Oracle 20C官方文档-SQL Language Reference
专栏大纲
7 Functions
7.9 ABS 7-23
7.10 ACOS 7-24
7.11 ADD_MONTHS 7-24
7.12 ANY_VALUE 7-25
7.13 APPROX_COUNT 7-26
7.14 APPROX_COUNT_DISTINCT 7-27
7.15 APPROX_COUNT_DISTINCT_AGG 7-28
7.16 APPROX_COUNT_DISTINCT_DETAIL 7-29
7.17 APPROX_MEDIAN 7-32
7.18 APPROX_PERCENTILE 7-35
7.19 APPROX_PERCENTILE_AGG 7-38
7.20 APPROX_PERCENTILE_DETAIL 7-39
7.21 APPROX_RANK 7-43
7.22 APPROX_SUM 7-44
7.23 ASCII 7-44
7.24 ASCIISTR 7-45
7.25 ASIN 7-46
7.26 ATAN 7-46
7.27 ATAN2 7-47
7.28 AVG 7-48
7.29 BFILENAME 7-49
7.30 BIN_TO_NUM 7-50
7.31 BITAND 7-52
7.34 BITMAP_BUCKET_NUMBER 7-55
7.35 BITMAP_CONSTRUCT_AGG 7-55
7.36 BITMAP_COUNT 7-56
7.37 BITMAP_OR_AGG 7-57
7.38 BIT_OR_AGG 7-57
7.39 BIT_XOR_AGG 7-58
7.40 CARDINALITY 7-59
7.41 CAST 7-59
7.42 CEIL 7-64
7.43 CHARTOROWID 7-65
7.44 CHECKSUM 7-66
7.45 CHR 7-66
7.46 CLUSTER_DETAILS 7-68
7.47 CLUSTER_DISTANCE 7-72
7.48 CLUSTER_ID 7-74
7.49 CLUSTER_PROBABILITY 7-77
7.50 CLUSTER_SET 7-79
7.51 COALESCE 7-82
7.52 COLLATION 7-84
7.53 COLLECT 7-85
7.54 COMPOSE 7-86
7.55 CON_DBID_TO_ID 7-87
7.56 CON_GUID_TO_ID 7-88
7.57 CON_NAME_TO_ID 7-89
7.58 CON_UID_TO_ID 7-89
7.59 CONCAT 7-90
7.60 CONVERT 7-91
7.61 CORR 7-93
7.62 CORR_* 7-94
7.62.1 CORR_S 7-96
7.62.2 CORR_K 7-96
7.63 COS 7-97
7.64 COSH 7-97
7.65 COUNT 7-98
7.66 COVAR_POP 7-100
7.67 COVAR_SAMP 7-102
7.68 CUBE_TABLE 7-103
7.69 CUME_DIST 7-105
7.70 CURRENT_DATE 7-107
7.71 CURRENT_TIMESTAMP 7-107
7.72 CV 7-108
7.73 DATAOBJ_TO_MAT_PARTITION 7-110
7.74 DATAOBJ_TO_PARTITION 7-110
7.75 DBTIMEZONE 7-111
7.76 DECODE 7-112
7.77 DECOMPOSE 7-113
7.78 DENSE_RANK 7-115
7.79 DEPTH 7-116
7.80 DEREF 7-117
7.81 DUMP 7-118
7.82 EMPTY_BLOB, EMPTY_CLOB 7-120
7.83 EXISTSNODE 7-121
7.84 EXP 7-122
7.85 EXTRACT (datetime) 7-123
7.86 EXTRACT (XML) 7-125
7.87 EXTRACTVALUE 7-126
7.88 FEATURE_COMPARE 7-128
7.89 FEATURE_DETAILS 7-130
7.90 FEATURE_ID 7-133
7.91 FEATURE_SET 7-135
7.92 FEATURE_VALUE 7-138
7.93 FIRST 7-141
7.94 FIRST_VALUE 7-143
7.95 FLOOR 7-145
7.96 FROM_TZ 7-146
7.97 GREATEST 7-147
7.98 GROUP_ID 7-148
7.99 GROUPING 7-149
7.100 GROUPING_ID 7-150
7.101 HEXTORAW 7-151
7.102 INITCAP 7-151
7.103 INSTR 7-152
ITERATION_NUMBER 7-154
JSON_ARRAY 7-155
JSON_ARRAYAGG 7-158
JSON Type Constructor 7-160
JSON_DATAGUIDE 7-161
JSON_MERGEPATCH 7-162
JSON_OBJECT 7-164
JSON_OBJECTAGG 7-169
JSON_QUERY 7-171
JSON_SCALAR 7-177
JSON_SERIALIZE 7-178
JSON_TABLE 7-180
JSON_TRANSFORM 7-191
JSON_VALUE 7-194
KURTOSIS_POP 7-201
KURTOSIS_SAMP 7-201
7.120 LAG 7-202
7.121 LAST 7-203
7.122 LAST_DAY 7-204
7.123 LAST_VALUE 7-205
7.124 LEAD 7-208
7.125 LEAST 7-209
7.126 LENGTH 7-210
7.127 LISTAGG 7-211
7.128 LN 7-215
7.129 LNNVL 7-216
7.130 LOCALTIMESTAMP 7-217
7.131 LOG 7-218
7.132 LOWER 7-219
7.133 LPAD 7-219
7.134 LTRIM 7-220
7.135 MAKE_REF 7-221
7.136 MAX 7-222
7.137 MEDIAN 7-224
7.138 MIN 7-226
7.139 MOD 7-227
7.140 MONTHS_BETWEEN 7-228
7.141 NANVL 7-229
7.142 NCHR 7-230
NEW_TIME 7-230
NEXT_DAY 7-231
NLS_CHARSET_DECL_LEN 7-232
NLS_CHARSET_ID 7-232
NLS_CHARSET_NAME 7-233
NLS_COLLATION_ID 7-234
NLS_COLLATION_NAME 7-234
NLS_INITCAP 7-236
NLS_LOWER 7-237
NLS_UPPER 7-238
NLSSORT 7-239
NTH_VALUE 7-242
NTILE 7-243
NULLIF 7-244
NUMTODSINTERVAL 7-245
NUMTOYMINTERVAL 7-246
7.159 NVL 7-247
7.160 NVL2 7-248
ORA_DM_PARTITION_NAME 7-249
ORA_DST_AFFECTED 7-251
ORA_DST_CONVERT 7-251
ORA_DST_ERROR 7-252
ORA_HASH 7-253
ORA_INVOKING_USER 7-254
ORA_INVOKING_USERID 7-254
7.168 PATH 7-255
PERCENT_RANK 7-256
PERCENTILE_CONT 7-258
PERCENTILE_DISC 7-260
7.172 POWER 7-262
POWERMULTISET 7-263
POWERMULTISET_BY_CARDINALITY 7-264
PREDICTION 7-265
PREDICTION_BOUNDS 7-270
PREDICTION_COST 7-271
PREDICTION_DETAILS 7-275
PREDICTION_PROBABILITY 7-280
PREDICTION_SET 7-284
PRESENTNNV 7-287
PRESENTV 7-289
PREVIOUS 7-290
7.184 RANK 7-291
RATIO_TO_REPORT 7-293
RAWTOHEX 7-294
RAWTONHEX 7-295
7.188 REF 7-295
REFTOHEX 7-296
REGEXP_COUNT 7-297
REGEXP_INSTR 7-302
REGEXP_REPLACE 7-305
REGEXP_SUBSTR 7-311
REGR_ (Linear Regression) Functions 7-314
REMAINDER 7-319
REPLACE 7-320
ROUND (date) 7-321
ROUND (number) 7-322
ROUND_TIES_TO_EVEN (number) 7-323
ROW_NUMBER 7-324
ROWIDTOCHAR 7-326
ROWIDTONCHAR 7-326
7.203 RPAD 7-327
7.204 RTRIM 7-328
7.205 SCN_TO_TIMESTAMP 7-329
7.206 SESSIONTIMEZONE 7-331
7.207 SET 7-331
7.208 SIGN 7-332
7.209 SIN 7-333
7.210 SINH 7-333
SKEWNESS_POP 7-334
SKEWNESS_SAMP 7-335
SOUNDEX 7-335
7.214 SQRT 7-336
STANDARD_HASH 7-337
STATS_BINOMIAL_TEST 7-338
STATS_CROSSTAB 7-339
STATS_F_TEST 7-340
STATS_KS_TEST 7-342
STATS_MODE 7-343
STATS_MW_TEST 7-344
STATS_ONE_WAY_ANOVA 7-346
STATS_T_TEST_* 7-347
STATS_T_TEST_ONE 7-349
STATS_T_TEST_PAIRED 7-349
STATS_T_TEST_INDEP and STATS_T_TEST_INDEPU 7-349
STATS_WSR_TEST 7-351
STDDEV 7-351
STDDEV_POP 7-353
STDDEV_SAMP 7-354
SUBSTR 7-356
7.229 SUM 7-357
SYS_CONNECT_BY_PATH 7-359
SYS_CONTEXT 7-360
SYS_DBURIGEN 7-368
SYS_EXTRACT_UTC 7-369
SYS_GUID 7-369
SYS_OP_ZONE_ID 7-370
SYS_TYPEID 7-372
SYS_XMLAGG 7-373
SYS_XMLGEN 7-374
SYSDATE 7-375
SYSTIMESTAMP 7-375
7.241 TAN 7-376
7.242 TANH 7-377
TIMESTAMP_TO_SCN 7-377
TO_APPROX_COUNT_DISTINCT 7-378
TO_APPROX_PERCENTILE 7-379
TO_BINARY_DOUBLE 7-380
TO_BINARY_FLOAT 7-382
TO_BLOB (bfile) 7-384
TO_BLOB (raw) 7-384
TO_CHAR (bfile|blob) 7-385
TO_CHAR (character) 7-385
TO_CHAR (datetime) 7-387
TO_CHAR (number) 7-393
TO_CLOB (bfile|blob) 7-396
TO_CLOB (character) 7-396
7.256 TO_DATE 7-397
7.257 TO_DSINTERVAL 7-399
7.258 TO_LOB 7-401
TO_MULTI_BYTE 7-402
TO_NCHAR (character) 7-403
TO_NCHAR (datetime) 7-404
TO_NCHAR (number) 7-405
TO_NCLOB 7-405
TO_NUMBER 7-406
TO_SINGLE_BYTE 7-407
TO_TIMESTAMP 7-408
TO_TIMESTAMP_TZ 7-410
TO_UTC_TIMESTAMP_TZ 7-411
TO_YMINTERVAL 7-413
TRANSLATE 7-415
TRANSLATE ... USING 7-416
7.272 TREAT 7-418
7.273 TRIM 7-419
TRUNC (date) 7-420
TRUNC (number) 7-422
TZ_OFFSET 7-423
7.277 UID 7-424
7.278 UNISTR 7-424
7.279 UPPER 7-425
7.280 USER 7-426
7.281 USERENV 7-426
7.282 VALIDATE_CONVERSION 7-428
7.283 VALUE 7-430
7.284 VAR_POP 7-431
7.285 VAR_SAMP 7-433
7.286 VARIANCE 7-434
7.287 VSIZE 7-435
WIDTH_BUCKET 7-436
XMLAGG 7-437
XMLCAST 7-439
XMLCDATA 7-439
XMLCOLATTVAL 7-440
XMLCOMMENT 7-441
XMLCONCAT 7-442
XMLDIFF 7-443
XMLELEMENT 7-444
XMLEXISTS 7-447
XMLFOREST 7-448
XMLISVALID 7-449
XMLPARSE 7-449
XMLPATCH 7-450
7.302 XMLPI 7-451
XMLQUERY 7-452
XMLSEQUENCE 7-454
XMLSERIALIZE 7-456
XMLTABLE 7-457
XMLTRANSFORM 7-460
ROUND and TRUNC Date Functions 7-461
About User-Defined Functions 7-463
Prerequisites 7-464
Name Precedence 7-464
7.309.2.1 Naming Conventions 7-465
7.9 ABS 7-23
7.10 ACOS 7-24
7.11 ADD_MONTHS 7-24
7.12 ANY_VALUE 7-25
7.13 APPROX_COUNT 7-26
7.14 APPROX_COUNT_DISTINCT 7-27
7.15 APPROX_COUNT_DISTINCT_AGG 7-28
7.16 APPROX_COUNT_DISTINCT_DETAIL 7-29
7.17 APPROX_MEDIAN 7-32
7.18 APPROX_PERCENTILE 7-35
7.19 APPROX_PERCENTILE_AGG 7-38
7.20 APPROX_PERCENTILE_DETAIL 7-39
7.21 APPROX_RANK 7-43
7.22 APPROX_SUM 7-44
7.23 ASCII 7-44
7.24 ASCIISTR 7-45
7.25 ASIN 7-46
7.26 ATAN 7-46
7.27 ATAN2 7-47
7.28 AVG 7-48
7.29 BFILENAME 7-49
7.30 BIN_TO_NUM 7-50
7.31 BITAND 7-52
7.34 BITMAP_BUCKET_NUMBER 7-55
7.35 BITMAP_CONSTRUCT_AGG 7-55
7.36 BITMAP_COUNT 7-56
7.37 BITMAP_OR_AGG 7-57
7.38 BIT_OR_AGG 7-57
7.39 BIT_XOR_AGG 7-58
7.40 CARDINALITY 7-59
7.41 CAST 7-59
7.42 CEIL 7-64
7.43 CHARTOROWID 7-65
7.44 CHECKSUM 7-66
7.45 CHR 7-66
7.46 CLUSTER_DETAILS 7-68
7.47 CLUSTER_DISTANCE 7-72
7.48 CLUSTER_ID 7-74
7.49 CLUSTER_PROBABILITY 7-77
7.50 CLUSTER_SET 7-79
7.51 COALESCE 7-82
7.52 COLLATION 7-84
7.53 COLLECT 7-85
7.54 COMPOSE 7-86
7.55 CON_DBID_TO_ID 7-87
7.56 CON_GUID_TO_ID 7-88
7.57 CON_NAME_TO_ID 7-89
7.58 CON_UID_TO_ID 7-89
7.59 CONCAT 7-90
7.60 CONVERT 7-91
7.61 CORR 7-93
7.62 CORR_* 7-94
7.62.1 CORR_S 7-96
7.62.2 CORR_K 7-96
7.63 COS 7-97
7.64 COSH 7-97
7.65 COUNT 7-98
7.66 COVAR_POP 7-100
7.67 COVAR_SAMP 7-102
7.68 CUBE_TABLE 7-103
7.69 CUME_DIST 7-105
7.70 CURRENT_DATE 7-107
7.71 CURRENT_TIMESTAMP 7-107
7.72 CV 7-108
7.73 DATAOBJ_TO_MAT_PARTITION 7-110
7.74 DATAOBJ_TO_PARTITION 7-110
7.75 DBTIMEZONE 7-111
7.76 DECODE 7-112
7.77 DECOMPOSE 7-113
7.78 DENSE_RANK 7-115
7.79 DEPTH 7-116
7.80 DEREF 7-117
7.81 DUMP 7-118
7.82 EMPTY_BLOB, EMPTY_CLOB 7-120
7.83 EXISTSNODE 7-121
7.84 EXP 7-122
7.85 EXTRACT (datetime) 7-123
7.86 EXTRACT (XML) 7-125
7.87 EXTRACTVALUE 7-126
7.88 FEATURE_COMPARE 7-128
7.89 FEATURE_DETAILS 7-130
7.90 FEATURE_ID 7-133
7.91 FEATURE_SET 7-135
7.92 FEATURE_VALUE 7-138
7.93 FIRST 7-141
7.94 FIRST_VALUE 7-143
7.95 FLOOR 7-145
7.96 FROM_TZ 7-146
7.97 GREATEST 7-147
7.98 GROUP_ID 7-148
7.99 GROUPING 7-149
7.100 GROUPING_ID 7-150
7.101 HEXTORAW 7-151
7.102 INITCAP 7-151
7.103 INSTR 7-152
ITERATION_NUMBER 7-154
JSON_ARRAY 7-155
JSON_ARRAYAGG 7-158
JSON Type Constructor 7-160
JSON_DATAGUIDE 7-161
JSON_MERGEPATCH 7-162
JSON_OBJECT 7-164
JSON_OBJECTAGG 7-169
JSON_QUERY 7-171
JSON_SCALAR 7-177
JSON_SERIALIZE 7-178
JSON_TABLE 7-180
JSON_TRANSFORM 7-191
JSON_VALUE 7-194
KURTOSIS_POP 7-201
KURTOSIS_SAMP 7-201
7.120 LAG 7-202
7.121 LAST 7-203
7.122 LAST_DAY 7-204
7.123 LAST_VALUE 7-205
7.124 LEAD 7-208
7.125 LEAST 7-209
7.126 LENGTH 7-210
7.127 LISTAGG 7-211
7.128 LN 7-215
7.129 LNNVL 7-216
7.130 LOCALTIMESTAMP 7-217
7.131 LOG 7-218
7.132 LOWER 7-219
7.133 LPAD 7-219
7.134 LTRIM 7-220
7.135 MAKE_REF 7-221
7.136 MAX 7-222
7.137 MEDIAN 7-224
7.138 MIN 7-226
7.139 MOD 7-227
7.140 MONTHS_BETWEEN 7-228
7.141 NANVL 7-229
7.142 NCHR 7-230
NEW_TIME 7-230
NEXT_DAY 7-231
NLS_CHARSET_DECL_LEN 7-232
NLS_CHARSET_ID 7-232
NLS_CHARSET_NAME 7-233
NLS_COLLATION_ID 7-234
NLS_COLLATION_NAME 7-234
NLS_INITCAP 7-236
NLS_LOWER 7-237
NLS_UPPER 7-238
NLSSORT 7-239
NTH_VALUE 7-242
NTILE 7-243
NULLIF 7-244
NUMTODSINTERVAL 7-245
NUMTOYMINTERVAL 7-246
7.159 NVL 7-247
7.160 NVL2 7-248
ORA_DM_PARTITION_NAME 7-249
ORA_DST_AFFECTED 7-251
ORA_DST_CONVERT 7-251
ORA_DST_ERROR 7-252
ORA_HASH 7-253
ORA_INVOKING_USER 7-254
ORA_INVOKING_USERID 7-254
7.168 PATH 7-255
PERCENT_RANK 7-256
PERCENTILE_CONT 7-258
PERCENTILE_DISC 7-260
7.172 POWER 7-262
POWERMULTISET 7-263
POWERMULTISET_BY_CARDINALITY 7-264
PREDICTION 7-265
PREDICTION_BOUNDS 7-270
PREDICTION_COST 7-271
PREDICTION_DETAILS 7-275
PREDICTION_PROBABILITY 7-280
PREDICTION_SET 7-284
PRESENTNNV 7-287
PRESENTV 7-289
PREVIOUS 7-290
7.184 RANK 7-291
RATIO_TO_REPORT 7-293
RAWTOHEX 7-294
RAWTONHEX 7-295
7.188 REF 7-295
REFTOHEX 7-296
REGEXP_COUNT 7-297
REGEXP_INSTR 7-302
REGEXP_REPLACE 7-305
REGEXP_SUBSTR 7-311
REGR_ (Linear Regression) Functions 7-314
REMAINDER 7-319
REPLACE 7-320
ROUND (date) 7-321
ROUND (number) 7-322
ROUND_TIES_TO_EVEN (number) 7-323
ROW_NUMBER 7-324
ROWIDTOCHAR 7-326
ROWIDTONCHAR 7-326
7.203 RPAD 7-327
7.204 RTRIM 7-328
7.205 SCN_TO_TIMESTAMP 7-329
7.206 SESSIONTIMEZONE 7-331
7.207 SET 7-331
7.208 SIGN 7-332
7.209 SIN 7-333
7.210 SINH 7-333
SKEWNESS_POP 7-334
SKEWNESS_SAMP 7-335
SOUNDEX 7-335
7.214 SQRT 7-336
STANDARD_HASH 7-337
STATS_BINOMIAL_TEST 7-338
STATS_CROSSTAB 7-339
STATS_F_TEST 7-340
STATS_KS_TEST 7-342
STATS_MODE 7-343
STATS_MW_TEST 7-344
STATS_ONE_WAY_ANOVA 7-346
STATS_T_TEST_* 7-347
STATS_T_TEST_ONE 7-349
STATS_T_TEST_PAIRED 7-349
STATS_T_TEST_INDEP and STATS_T_TEST_INDEPU 7-349
STATS_WSR_TEST 7-351
STDDEV 7-351
STDDEV_POP 7-353
STDDEV_SAMP 7-354
SUBSTR 7-356
7.229 SUM 7-357
SYS_CONNECT_BY_PATH 7-359
SYS_CONTEXT 7-360
SYS_DBURIGEN 7-368
SYS_EXTRACT_UTC 7-369
SYS_GUID 7-369
SYS_OP_ZONE_ID 7-370
SYS_TYPEID 7-372
SYS_XMLAGG 7-373
SYS_XMLGEN 7-374
SYSDATE 7-375
SYSTIMESTAMP 7-375
7.241 TAN 7-376
7.242 TANH 7-377
TIMESTAMP_TO_SCN 7-377
TO_APPROX_COUNT_DISTINCT 7-378
TO_APPROX_PERCENTILE 7-379
TO_BINARY_DOUBLE 7-380
TO_BINARY_FLOAT 7-382
TO_BLOB (bfile) 7-384
TO_BLOB (raw) 7-384
TO_CHAR (bfile|blob) 7-385
TO_CHAR (character) 7-385
TO_CHAR (datetime) 7-387
TO_CHAR (number) 7-393
TO_CLOB (bfile|blob) 7-396
TO_CLOB (character) 7-396
7.256 TO_DATE 7-397
7.257 TO_DSINTERVAL 7-399
7.258 TO_LOB 7-401
TO_MULTI_BYTE 7-402
TO_NCHAR (character) 7-403
TO_NCHAR (datetime) 7-404
TO_NCHAR (number) 7-405
TO_NCLOB 7-405
TO_NUMBER 7-406
TO_SINGLE_BYTE 7-407
TO_TIMESTAMP 7-408
TO_TIMESTAMP_TZ 7-410
TO_UTC_TIMESTAMP_TZ 7-411
TO_YMINTERVAL 7-413
TRANSLATE 7-415
TRANSLATE ... USING 7-416
7.272 TREAT 7-418
7.273 TRIM 7-419
TRUNC (date) 7-420
TRUNC (number) 7-422
TZ_OFFSET 7-423
7.277 UID 7-424
7.278 UNISTR 7-424
7.279 UPPER 7-425
7.280 USER 7-426
7.281 USERENV 7-426
7.282 VALIDATE_CONVERSION 7-428
7.283 VALUE 7-430
7.284 VAR_POP 7-431
7.285 VAR_SAMP 7-433
7.286 VARIANCE 7-434
7.287 VSIZE 7-435
WIDTH_BUCKET 7-436
XMLAGG 7-437
XMLCAST 7-439
XMLCDATA 7-439
XMLCOLATTVAL 7-440
XMLCOMMENT 7-441
XMLCONCAT 7-442
XMLDIFF 7-443
XMLELEMENT 7-444
XMLEXISTS 7-447
XMLFOREST 7-448
XMLISVALID 7-449
XMLPARSE 7-449
XMLPATCH 7-450
7.302 XMLPI 7-451
XMLQUERY 7-452
XMLSEQUENCE 7-454
XMLSERIALIZE 7-456
XMLTABLE 7-457
XMLTRANSFORM 7-460
ROUND and TRUNC Date Functions 7-461
About User-Defined Functions 7-463
Prerequisites 7-464
Name Precedence 7-464
7.309.2.1 Naming Conventions 7-465
专栏目录
- 7 Oracle 函数
- 7.9 ABS
- 7.10 ACOS
- 7.11 ADD_MONTHS
- 7.12 ANY_VALUE
- 7.13 APPROX_COUNT
- 7.14 APPROX_COUNT_DISTINCT
- 7.15 APPROX_COUNT_DISTINCT_AGG
- 7.16 APPROX_COUNT_DISTINCT_DETAIL
- 7.17 APPROX_MEDIAN
- 7.18 APPROX_PERCENTILE
- 7.19 APPROX_PERCENTILE_AGG
- 7.20 APPROX_PERCENTILE_DETAIL
- 7.21 APPROX_RANK
- 7.22 APPROX_SUM
- 7.23 ASCII
- 7.24 ASCIISTR
- 7.25 ASIN
- 7.27 ATAN2
- 7.28 AVG
- 7.26 ATAN
- 7.29 BFILENAME
- 7.30 BIN_TO_NUM
- 7.31 BITAND
- 7.32 BIT_AND_AGG
- 7.33 BITMAP_BIT_POSITION
- 7.34 BITMAP_BUCKET_NUMBER
- 7.35 BITMAP_CONSTRUCT_AGG
- 7.36 BITMAP_COUNT
- 7.37 BITMAP_OR_AGG
- 7.39 BIT_XOR_AGG
- 7.40 CARDINALITY
- 7.42 CEIL
- 7.43 CHARTOROWID
- 7.44CHECKSUM
- 7.45 CHR
- 7.47 CLUSTER_DISTANCE
- 7.46 CLUSTER_DETAILS
- 7.48 CLUSTER_ID
- 7.49 CLUSTER_PROBABILITY
- 7.50 CLUSTER_SET
- 7.51 COALESCE
- 7.52 COLLATION
- 7.53 COLLECT
- 7.54 COMPOSE
- 7.55 CON_DBID_TO_ID
- 7.56 CON_GUID_TO_ID
- 7.57 CON_NAME_TO_ID
- 7.58 CON_UID_TO_ID
- 7.59 CONCAT
- 7.60 CONVERT
- 7.61 CORR
- 7.62 CORR_*
- 7.63 COS
- 7.64 COSH
- 7.65 COUNT
- 7.66 COVAR_POP
- 7.67 COVAR_SAMP
- 7.68 CUBE_TABLE
- 7.69 CUME_DIST
- 7.70 CURRENT_DATE
- 7.71 CURRENT_TIMESTAMP
- 7.72 CV
- 7.73 DATAOBJ_TO_MAT_PARTITION
- 7.74 DATAOBJ_TO_PARTITION
- 7.75 DBTIMEZONE
- 7.76 DECODE
- 7.41 CAST
- 7.78 DENSE_RANK
- 7.81 DUMP
- 7.79 DEPTH
- 7.80 DEREF
- 7.82 EMPTY_BLOB, EMPTY_CLOB
- 7.83 EXISTSNODE
- 7.84 EXP
- 7.85 EXTRACT (datetime)
- 7.86 EXTRACT (XML)
- 7.87 EXTRACTVALUE
- 7.88 FEATURE_COMPARE
- 7.89 FEATURE_DETAILS
- 7.90 FEATURE_ID
- 7.91 FEATURE_SET
- 7.92 FEATURE_VALUE
- 7.93 FIRST
- 7.94 FIRST_VALUE
- 7.95 FLOOR
- 7.96 FROM_TZ
- 7.97 GREATEST
- 7.98 GROUP_ID
- 7.99 GROUPING
- 7.100 GROUPING_ID
- 7.101 HEXTORAW
- 7.102 INITCAP
- 7.103 INSTR
- 7.104 ITERATION_NUMBER
- 7.105 JSON_ARRAY
- 7.106 JSON_ARRAYAGG
- 7.107 JSON Type Constructor
- 7.108 JSON_DATAGUIDE
- 7.109 JSON_MERGEPATCH
- 7.120 LAG
- 7.121 LAST
- 7.122 LAST_DAY
购买须知
本专栏为图文内容课程。
付费用户可享受文章永久阅读权限。
付费用户可获取折扣购买数据库、架构师大会权限。
本课程为虚拟产品，一经付费概不退款，敬请谅解。
付费用户可享受文章永久阅读权限。
付费用户可获取折扣购买数据库、架构师大会权限。
本课程为虚拟产品，一经付费概不退款，敬请谅解。
更多专栏推荐
-
Oracle 19c 官方文档系列-《Database Administrator’s Guide》
¥0 wuweilong
-
阿里云大数据AI技术
¥0 阿里云大数据AI技术
-
Java架构精选
¥0 lihong
