Mark'sBLOG
CARD
jinyaoMa
issue, func, flow, std, solve
15 | 8 | 24
SKIN
SETTINGS
Night Shift
Disable Canvas
简体中文
中文
|
English
|
日本語
PAGE CONTENT
Oracle SQL Basic Usage
2019-06-19
2019-06-19
Note , SQL
133
1 min.

Oracle SQL 复习笔记(进行中放弃了...)

# 笔记 / Cheat Sheet

concat(field/string, field/string, field/string...)
length(field/string)
round(number, [integer])
in(string, string...)
left(field/string, unsignedInteger) => js => field/string.substring(0, unsignedInteger)
replace(field/string, searchString, replacementString)
where, or, xor, and, != (<>), like, '_%', between ?number and ?number (both number inclusive), not ?operator
sum(field)
select distinct field => non-repeated/unique value
-- inline comment, a space after --
/* mutiple-line comment, a space at the very beginning and ending */
order by
all(table) => where field > all(select num from nums) -- find something with a field's number larger than all the num from nums
count(field)
group by field
having -- must only be used after 'group by' that can use sum(), count(), etc.
The post above ended Thanks for your reading
Come on! Write some comments, and your suggestions will improve the quality of my creative!
FRIEND ME
QQ
WeChat
Post Author: jinyaoMa
Post Link: /
Copyright Notice: All articles/posts in this website are licensed under BY-NC-SA unless stating additionally.
Enable Read Mode
COMMENTS
DEFAULT