oracle sql reference官方文档,Oracle 20C官方文档-SQL Language Reference

Oracle 20C官方文档-SQL Language Reference

免费

专栏简介

Oracle 20C官方文档-SQL Language Reference

专栏大纲

7Functions

7.9ABS7-23

7.10ACOS7-24

7.11ADD_MONTHS7-24

7.12ANY_VALUE7-25

7.13APPROX_COUNT7-26

7.14APPROX_COUNT_DISTINCT7-27

7.15APPROX_COUNT_DISTINCT_AGG7-28

7.16APPROX_COUNT_DISTINCT_DETAIL7-29

7.17APPROX_MEDIAN7-32

7.18APPROX_PERCENTILE7-35

7.19APPROX_PERCENTILE_AGG7-38

7.20APPROX_PERCENTILE_DETAIL7-39

7.21APPROX_RANK7-43

7.22APPROX_SUM7-44

7.23ASCII7-44

7.24ASCIISTR7-45

7.25ASIN7-46

7.26ATAN7-46

7.27ATAN27-47

7.28AVG7-48

7.29BFILENAME7-49

7.30BIN_TO_NUM7-50

7.31BITAND7-52

7.34BITMAP_BUCKET_NUMBER7-55

7.35BITMAP_CONSTRUCT_AGG7-55

7.36BITMAP_COUNT7-56

7.37BITMAP_OR_AGG7-57

7.38BIT_OR_AGG7-57

7.39BIT_XOR_AGG7-58

7.40CARDINALITY7-59

7.41CAST7-59

7.42CEIL7-64

7.43CHARTOROWID7-65

7.44CHECKSUM7-66

7.45CHR7-66

7.46CLUSTER_DETAILS7-68

7.47CLUSTER_DISTANCE7-72

7.48CLUSTER_ID7-74

7.49CLUSTER_PROBABILITY7-77

7.50CLUSTER_SET7-79

7.51COALESCE7-82

7.52COLLATION7-84

7.53COLLECT7-85

7.54COMPOSE7-86

7.55CON_DBID_TO_ID7-87

7.56CON_GUID_TO_ID7-88

7.57CON_NAME_TO_ID7-89

7.58CON_UID_TO_ID7-89

7.59CONCAT7-90

7.60CONVERT7-91

7.61CORR7-93

7.62CORR_*7-94

7.62.1CORR_S7-96

7.62.2CORR_K7-96

7.63COS7-97

7.64COSH7-97

7.65COUNT7-98

7.66COVAR_POP7-100

7.67COVAR_SAMP7-102

7.68CUBE_TABLE7-103

7.69CUME_DIST7-105

7.70CURRENT_DATE7-107

7.71CURRENT_TIMESTAMP7-107

7.72CV7-108

7.73DATAOBJ_TO_MAT_PARTITION7-110

7.74DATAOBJ_TO_PARTITION7-110

7.75DBTIMEZONE7-111

7.76DECODE7-112

7.77DECOMPOSE7-113

7.78DENSE_RANK7-115

7.79DEPTH7-116

7.80DEREF7-117

7.81DUMP7-118

7.82EMPTY_BLOB, EMPTY_CLOB7-120

7.83EXISTSNODE7-121

7.84EXP7-122

7.85EXTRACT (datetime)7-123

7.86EXTRACT (XML)7-125

7.87EXTRACTVALUE7-126

7.88FEATURE_COMPARE7-128

7.89FEATURE_DETAILS7-130

7.90FEATURE_ID7-133

7.91FEATURE_SET7-135

7.92FEATURE_VALUE7-138

7.93FIRST7-141

7.94FIRST_VALUE7-143

7.95FLOOR7-145

7.96FROM_TZ7-146

7.97GREATEST7-147

7.98GROUP_ID7-148

7.99GROUPING7-149

7.100GROUPING_ID7-150

7.101HEXTORAW7-151

7.102INITCAP7-151

7.103INSTR7-152

ITERATION_NUMBER7-154

JSON_ARRAY7-155

JSON_ARRAYAGG7-158

JSON Type Constructor7-160

JSON_DATAGUIDE7-161

JSON_MERGEPATCH7-162

JSON_OBJECT7-164

JSON_OBJECTAGG7-169

JSON_QUERY7-171

JSON_SCALAR7-177

JSON_SERIALIZE7-178

JSON_TABLE7-180

JSON_TRANSFORM7-191

JSON_VALUE7-194

KURTOSIS_POP7-201

KURTOSIS_SAMP7-201

7.120LAG7-202

7.121LAST7-203

7.122LAST_DAY7-204

7.123LAST_VALUE7-205

7.124LEAD7-208

7.125LEAST7-209

7.126LENGTH7-210

7.127LISTAGG7-211

7.128LN7-215

7.129LNNVL7-216

7.130LOCALTIMESTAMP7-217

7.131LOG7-218

7.132LOWER7-219

7.133LPAD7-219

7.134LTRIM7-220

7.135MAKE_REF7-221

7.136MAX7-222

7.137MEDIAN7-224

7.138MIN7-226

7.139MOD7-227

7.140MONTHS_BETWEEN7-228

7.141NANVL7-229

7.142NCHR7-230

NEW_TIME7-230

NEXT_DAY7-231

NLS_CHARSET_DECL_LEN7-232

NLS_CHARSET_ID7-232

NLS_CHARSET_NAME7-233

NLS_COLLATION_ID7-234

NLS_COLLATION_NAME7-234

NLS_INITCAP7-236

NLS_LOWER7-237

NLS_UPPER7-238

NLSSORT7-239

NTH_VALUE7-242

NTILE7-243

NULLIF7-244

NUMTODSINTERVAL7-245

NUMTOYMINTERVAL7-246

7.159NVL7-247

7.160NVL27-248

ORA_DM_PARTITION_NAME7-249

ORA_DST_AFFECTED7-251

ORA_DST_CONVERT7-251

ORA_DST_ERROR7-252

ORA_HASH7-253

ORA_INVOKING_USER7-254

ORA_INVOKING_USERID7-254

7.168PATH7-255

PERCENT_RANK7-256

PERCENTILE_CONT7-258

PERCENTILE_DISC7-260

7.172POWER7-262

POWERMULTISET7-263

POWERMULTISET_BY_CARDINALITY7-264

PREDICTION7-265

PREDICTION_BOUNDS7-270

PREDICTION_COST7-271

PREDICTION_DETAILS7-275

PREDICTION_PROBABILITY7-280

PREDICTION_SET7-284

PRESENTNNV7-287

PRESENTV7-289

PREVIOUS7-290

7.184RANK7-291

RATIO_TO_REPORT7-293

RAWTOHEX7-294

RAWTONHEX7-295

7.188REF7-295

REFTOHEX7-296

REGEXP_COUNT7-297

REGEXP_INSTR7-302

REGEXP_REPLACE7-305

REGEXP_SUBSTR7-311

REGR_ (Linear Regression) Functions7-314

REMAINDER7-319

REPLACE7-320

ROUND (date)7-321

ROUND (number)7-322

ROUND_TIES_TO_EVEN (number)7-323

ROW_NUMBER7-324

ROWIDTOCHAR7-326

ROWIDTONCHAR7-326

7.203RPAD7-327

7.204RTRIM7-328

7.205SCN_TO_TIMESTAMP7-329

7.206SESSIONTIMEZONE7-331

7.207SET7-331

7.208SIGN7-332

7.209SIN7-333

7.210SINH7-333

SKEWNESS_POP7-334

SKEWNESS_SAMP7-335

SOUNDEX7-335

7.214SQRT7-336

STANDARD_HASH7-337

STATS_BINOMIAL_TEST7-338

STATS_CROSSTAB7-339

STATS_F_TEST7-340

STATS_KS_TEST7-342

STATS_MODE7-343

STATS_MW_TEST7-344

STATS_ONE_WAY_ANOVA7-346

STATS_T_TEST_*7-347

STATS_T_TEST_ONE7-349

STATS_T_TEST_PAIRED7-349

STATS_T_TEST_INDEP and STATS_T_TEST_INDEPU7-349

STATS_WSR_TEST7-351

STDDEV7-351

STDDEV_POP7-353

STDDEV_SAMP7-354

SUBSTR7-356

7.229SUM7-357

SYS_CONNECT_BY_PATH7-359

SYS_CONTEXT7-360

SYS_DBURIGEN7-368

SYS_EXTRACT_UTC7-369

SYS_GUID7-369

SYS_OP_ZONE_ID7-370

SYS_TYPEID7-372

SYS_XMLAGG7-373

SYS_XMLGEN7-374

SYSDATE7-375

SYSTIMESTAMP7-375

7.241TAN7-376

7.242TANH7-377

TIMESTAMP_TO_SCN7-377

TO_APPROX_COUNT_DISTINCT7-378

TO_APPROX_PERCENTILE7-379

TO_BINARY_DOUBLE7-380

TO_BINARY_FLOAT7-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.256TO_DATE7-397

7.257TO_DSINTERVAL7-399

7.258TO_LOB7-401

TO_MULTI_BYTE7-402

TO_NCHAR (character)7-403

TO_NCHAR (datetime)7-404

TO_NCHAR (number)7-405

TO_NCLOB7-405

TO_NUMBER7-406

TO_SINGLE_BYTE7-407

TO_TIMESTAMP7-408

TO_TIMESTAMP_TZ7-410

TO_UTC_TIMESTAMP_TZ7-411

TO_YMINTERVAL7-413

TRANSLATE7-415

TRANSLATE ... USING7-416

7.272TREAT7-418

7.273TRIM7-419

TRUNC (date)7-420

TRUNC (number)7-422

TZ_OFFSET7-423

7.277UID7-424

7.278UNISTR7-424

7.279UPPER7-425

7.280USER7-426

7.281USERENV7-426

7.282VALIDATE_CONVERSION7-428

7.283VALUE7-430

7.284VAR_POP7-431

7.285VAR_SAMP7-433

7.286VARIANCE7-434

7.287VSIZE7-435

WIDTH_BUCKET7-436

XMLAGG7-437

XMLCAST7-439

XMLCDATA7-439

XMLCOLATTVAL7-440

XMLCOMMENT7-441

XMLCONCAT7-442

XMLDIFF7-443

XMLELEMENT7-444

XMLEXISTS7-447

XMLFOREST7-448

XMLISVALID7-449

XMLPARSE7-449

XMLPATCH7-450

7.302XMLPI7-451

XMLQUERY7-452

XMLSEQUENCE7-454

XMLSERIALIZE7-456

XMLTABLE7-457

XMLTRANSFORM7-460

ROUND and TRUNC Date Functions7-461

About User-Defined Functions7-463

Prerequisites7-464

Name Precedence7-464

7.309.2.1Naming Conventions7-465

专栏目录

购买须知

本专栏为图文内容课程。

付费用户可享受文章永久阅读权限。

付费用户可获取折扣购买数据库、架构师大会权限。

本课程为虚拟产品，一经付费概不退款，敬请谅解。