Use Character, Number, and Date Functions in SELECT Statements
❑ The INITCAP function accepts a string of characters and returns each word
in title case.
❑ The function that computes the number of characters in a string including
spaces and special characters is the LENGTH function.
❑ The INSTR function returns the positional location of the nth occurrence of
a specified string of characters in a source string.
❑ The SUBSTR function extracts and returns a segment from a given source
string.
❑ The REPLACE function substitutes each occurrence of a search item in the
source string with a replacement term and returns the modified source string.
❑ A modulus operation returns the remainder of a division operation and is
available via the MOD function.
❑ The numeric ROUND function rounds numbers either up or down to the
specified degree of precision.
❑ The SYSDATE function is traditionally executed against the DUAL table
and returns current date and time of the database server.
❑ Date types store century, year, month, day, hour, minutes, and seconds
information.
❑ The difference between two date items is always a number that represents the
number of days between these two items.
Format Element Description Result
Y Last digit of year 5
YY Last two digits of year 75
YYY Last three digits of year 975
YYYY Four-digit year 1975
RR Two-digit year (see Chapter 3 for details) 75
YEAR Case-sensitive English spelling of year NINETEEN
SEVENTY-FIVE
MM Two-digit month 06
MON Three-letter abbreviation of month JUN
MONTH Case-sensitive English spelling of month JUNE
D Day of the week 2
DD Two-digit day of month 02
DDD Day of the year 153
DY Three-letter abbreviation of day MON
DAY Case-sensitive English spelling of day MONDAY
分享到:
相关推荐
oracle11g官方中文帮助 Oracle 11g:ORACLE ACTIVE DATA GUARD.pdf Oracle Database 11g 高可用性.pdf Oracle 数据库 11g 中的分区.pdf Oracle 数据库 11g :真正应用测试与可管理性概述.pdf Oracle 数据库 11g...
Oracle 11g 官方中文文档 包括一下部分文档: Oracle 11g:ORACLE ACTIVE DATA GUARD.pdf Oracle Database 11g 高可用性.pdf Oracle 数据库 11g :真正应用测试与可管理性概述.pdf Oracle 数据库 11g 中的分区....
Oracle 11g是一款甲骨文公司成功打造的功能强大的关系数据库管理系统,目前共发行了linux版本和windows版本,Oracle数据库的高效性、安全性、稳定性、延展性,是其成功的关键因素,世界上的几乎所有大型信息化系统都...
Oracle 11g 官方中文文档 包括: Oracle 11g:ORACLE ACTIVE DATA GUARD.pdf Oracle Database 11g 高可用性.pdf Oracle 数据库 11g :真正应用测试与可管理性概述.pdf Oracle 数据库 11g 中的分区.pdf Oracle 数据库...
oracle11g驱动包
oracle11g安装步骤.oracle11g安装步骤.oracle11g安装步骤.oracle11g安装步骤.
ojdbc678,oracle11g驱动
oracle11g自动建库oracle11g自动建库oracle11g自动建库oracle11g自动建库oracle11g自动建库
oracle 11g p10350787_111070升级补丁oracle 11g p10350787_111070升级补丁
这个文档,涵盖了64位oracle11g服务端的安装,因为我的win7系统是64位的,所以你们可以根据系统定安32还是64的,但是客户端和plsql是32位的,这个不区分,因为一般网上这两个都是免安装的文件夹形式,只需要拿过来...
Oracle 11g 官方中文文档集萃 包括: Oracle 11g:ORACLE ACTIVE DATA GUARD.pdf Oracle Database 11g 高可用性.pdf Oracle 数据库 11g :真正应用测试与可管理性概述.pdf Oracle 数据库 11g 中的分区.pdf Oracle ...
Windows环境使用exp,imp,expdp,impdp,sqldur2等导入导出数据命令的时候,需要安装Oracle11g客户端环境
oracle 11g gateway
包含oracle 11g和12c的ojdbc驱动: Oracle Database 12c Release 2 (12.2.0.1) drivers Oracle Database 12c Release 1 (12.1.0.2) drivers Oracle Database 12c Release 1 (12.1.0.1) drivers Oracle Database ...
龙蜥anolis系统oracle11g安装包,内含安装脚本支持龙蜥系统下自动安装数据库,并还原数据库dmp文件
Linux版本 Oracle11g数据库 64位 完整安装包
在centos下安装oracle11g 使用yum源进行搭建 包括配置监听
Oracle11g在windows服务器部署记录文档,以及遇到的问题和解决方法