Single-line function of SQL

Single-line function syntax:

Function name (COLUMN|EXPRESSION,[ARG1,ARG2,...] ）

Parameter description:

Function name: Names of functions

Column: Database columns name

Expression: string or computer expressions

ARG1,ARG2: Using Parameters in functions

Single-line function classification:

String function: Accepts character input and returns characters or values

Upper ()--Convert to uppercase

Initcap ()--Capitalize the first letter

SUBSTR ()--string intercept

Replace ()--content substitution

Numeric functions: Accepts numeric inputs and returns values

Rounding: ROUND ()

Truncation decimal bit: TRUNC ()

Remainder: MOD ()

Date functions: Manipulating date-based data

Conversion functions: Converting from one data type to another data type

General functions: NVL functions, decode functions

Single-line function of SQL