Table of Contents [Hide/Show]
Operators Comparison Operators Order of Precence Numeric Functions Character Functions Date Functions Notes Functions Data-Type Conversion Functions Functions Number Format Elements Date Format Elements Time Format Elements Other Format Elements Suffixes Affecting Number Display Aggregate Functions
BETWEEN m AND n
ORDER BY
IN (list)
= ANY
LIKE
%
_
ESCAPE
WHERE dname LIKE '%\_%' ESCAPE '\'
dname = 'HEAD_QUARTERS'
IS NULL
NOT
AND
OR
ROUND(number, n)
number
n
TRUNC(number, n)
MOD(m, n)
m
LOWER(string)
string
UPPER(string)
INITCAP(string)
CONCAT(string1, string2)
string1
string2
string1 || string2
SUBSTR(string, start, len)
len
expr
start
INSTR(string, substring)
LENGTH(string)
LPAD(string1, num, pad)
pad
num
RPAD(string1,num ,pad)
TRIM(LEADING | TRAILING | BOTH, trimchar FROM trimsource)
trimsource
DD-MON-YY
SYSDATE
select sysdate from dual
date + number
date
TRUNC(date)
date - number
date1 - date2
date1
date2
date + number/24
MONTHS_BETWEEN(date1, date2)
ADD_MONTHS(date, n)
TO_CHAR(number | date, [fmt], [nlsparams])
fmt
nlsparams
TO_NUMBER(char, [fmt] , [nlsparams])
TO_DATE(char, [fmt] , [nlsparams]
9
999999
1234
0
99999
$
$999,999
$1,234
L
L999999
FF1234
.
999999.99
,
999,999
1,234
MI
999999MI
1234-
PR
999999PR
-1234
EEEE
99.999EEEE
1.23E+03
V
10n
9999V99
123400
B
B9999.99
SCC
CC
S
-
YYYY
SYYYY
YYY
YY
Y
RR
Y,YYYY
IYYY
IYY
IY
I
SYEAR
YEAR
BC
AD
B.C.
A.D.
Q
MM
MONTH
MON
RM
WW
W
DDD
DD
D
DAY
DY
J
AM
PM
A.M.
P.M.
HH
HH12
HH24
SS
SSSSS
/ . ,
"of the"
TH
DDTH
4TH
SP
DDSP
FOUR
SPTH
THSP
DDSPTH
FOURTH
AVG([DISTINCT | ALL] expr)
COUNT(* | [DISTINCT | ALL] expr)
*
MAX([DISTINCT | ALL] expr)
MIN([DISTINCT | ALL] expr)
STDDEV([DISTINCT | ALL] expr)
SUM([DISTINCT | ALL] expr)
VARIANCE([DISTINCT | ALL] expr)
ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.