OracleDB入门教程（PPT+DOC)资源-CSDN文库

共6个文件

doc：3个

ppt：3个

需积分: 3 132 浏览量 2008-03-08 12:40:14 上传评论收藏 6.53MB ZIP 举报

资源推荐

资源详情

资源评论

收起资源包目录

package

OracleDB_入门.zip （6个子文件）

Intro_to_Ora9i_Chap01.doc 622KB

Intro_to_Ora9i_Chap01.ppt 151KB

Intro_to_Ora9i_Chap02.ppt 117KB

Intro_to_Ora9i_Chap02.doc 1.94MB

Intro_to_Ora9i_Chap03.doc 4.73MB

Intro_to_Ora9i_Chap03.ppt 99KB

Chapter 3. Single-Row Functions

Null value function NVL(x1, x2) (p114):

Returns x2 if x1 is null, otherwise returns x1.

• Null value function NVL2(x1, x2, x3) (p115):

Returns x3 if x1 is null, otherwise returns x2.

• The most used character functions (p116-117) :

– ASCII(c1) (p118)

Returns the corresponding decimal equivalent of the 1

st

char in c1.

– Chr(i) (p118)

Returns the corresponding character of the decimal representation.

– Concat(c1,c2) (p118)

Returns c1 appended by c2.

– Initcap(c1) (p118)

Returns c1 with the 1

st

character of each word in uppercase.

– Instr(c1, c2, i, j) (p118)

Returns the position in c1 where the jth c2 is found, begining at i position.

– Length(c1) (p121)

Returns the length in characters of c1.

内容反馈

baobaoqin

粉丝: 2
资源: 4

最新资源

资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！点击此处反馈

feedback-tip