Common functions of Oralce SQL language (1)

Common functions of Oralce SQL language (I) character functions this function generally receives characters as parameters and can return characters or numbers. The most common functions are. the CONCAT function is mainly used for string connection. The specific syntax is as follows: CONCAT (c1, c2) receives two parameters and connects the second parameter to the end of the first parameter. If the second parameter is NULL, the function returns the first parameter. If the first parameter is NULL, the second parameter is returned. If both are NULL, the function returns NULL www.2cto.com to add RMB for the product price. Example:
2. the NVL function is used to replace NVL (e1, e2) with two parameters. If the first parameter is not NULL, the function returns the first parameter, if the first parameter is NULL, the function returns the following example, "No detailed description" is displayed for the default settings of products that are not described in detail"

There are still many common functions that can be used to replace NULL characters with no detailed descriptions. I hope you can comment on them on my basis.