- 1、本文档共25页,可阅读全部内容。
- 2、原创力文档(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
oracle函数大全(国外英语资料)
oracle函数大全(国外英语资料)
ORACLE function Daquan
1., the first lecture, one-way function and group function explain
PL/SQL single line function and group function detailed explanation
A function is a program that has zero or more arguments and has a return value. In SQL, Oracle constructs a series of functions that can be called SQL or PL/SQL statements, and functions are divided into two broad categories:
Single-Row Functions
Group function
This article will discuss how to use single function and use rules.
Single function in SQL
SQL and PL/SQL come with many types of functions, such as characters, numbers, dates, conversions, and mixed functions. They are used to process single line data, so these can be collectively referred to as one-way functions. These functions can be used in SELECT, WHERE, ORDER, BY, etc., for example, the following example contains the TO_CHAR, UPPER, SOUNDEX and other one-way functions.
SELECT, ename, TO_CHAR (hiredate,day, DD-Mon-YYYY), FROM, empWhere, UPPER (ename), Like,AL%ORDER, BY, SOUNDEX (ename)
The one-way function can also be used in other statements, such as the SET update clause, the VALUES clause INSERT, WHERE clause DELET, certification exam pay special attention to the use of these functions in the SELECT statement, so our attention is also focused on the SELECT statement.
NULL and one-way functions
Its hard to start on how to understand NULL, and even an experienced person is baffled. NULL represents the value of an unknown data or a null value, any operand arithmetic operators for the NULL value, the results are all provided with a NULL value, this rule is suitable for many functions, only CONCAT, DECODE, DUMP, NVL, REPLACE can call the NULL parameter returns a non NULL value. In these, the NVL function is most important because he can process NULL values directly; NVL has two parameters: NVL (x1, x2), X1 and X2 all expressions, returns X2 when X1 is null, or returns x1.
Lets take a look at the EMP data sheet, which contains two i
您可能关注的文档
最近下载
- 教育、科技、人才一体化与新质生产力发展.pptx VIP
- 2024年湖南水利水电职业技术学院单招职业技能测试题库含答案(研优卷).docx VIP
- 教育、科技、人才一体化视域下发展新质生产力的四重逻辑和实践路径.docx VIP
- 教育、科技、人才一体化视域下发展新质生产力的四重逻辑和实践路径.docx VIP
- 《大棚番茄基质槽式栽培技术规程》.docx
- 立体车库 毕业论文外文翻译.docx VIP
- 教育、科技、人才一体推进新质生产力发展.docx VIP
- 2024年湖南水利水电职业技术学院单招职业技能测试题库含答案(考试直接用).docx VIP
- 社交礼仪教程(第7版 微课版)课件 第五章 餐饮礼仪.pptx
- 2025清华:DeepSeek从入门到精通.pdf
文档评论(0)