space¶
This function is used to return a specified number of spaces.
Syntax¶
space(bigint <n>)
Parameters¶
Parameter | Mandatory | Type | Description |
|---|---|---|---|
n | Yes | BIGINT | Number of spaces |
Return Values¶
The return value is of the STRING type.
Note
If the value of n is empty, an error is reported.
If the value of n is NULL, NULL is returned.
Example Code¶
The value 6 is returned.
select length(space(6));