Operating on Character Data
lower('SQL') = sql
upper('sql') = SQL
initcap('sql') = Sql
length('A short string') = 14
concat('SQL is',' easy to learn.') = SQL is easy to learn.
substr('http://www.domain.com',12,6) = domain
instr('http://www.domain.com','.',1,2) = 18
rpad('#PASSWORD#',11,'#') = #PASSWORD##
lpad('#PASSWORD#',11,'#') = ##PASSWORD#
trim('#' from '#PASSWORD#') = PASSWORDreplace('#PASSWORD#','WORD','PORT') = #PASSPORT#
Operating on Numeric Data
round(42.39,1) = 42.4
trunc(42.39,1) = 42.3
mod(42,10) = 2
Operating on Date Information
months_between('01-FEB-2008','01-JAN-2008') = 1
add_months('01-JAN-2008',1) = 01-FEB-2008last_day('01-FEB-2008') = 29-FEB-2008
next_day('01-FEB-2008','Friday') = 08-FEB-2008sysdate = 17-DEC-2007
round(sysdate,'month') = 01-JAN-2008
trunc(sysdate,'month') = 01-DEC-2007
Oracle常用函数示例
最新推荐文章于 2022-04-02 16:06:01 发布