Common functions of Oralce SQL

Character Functions

This function generally receives characters as parameters and can return characters or numbers.

The following two functions are commonly used:

1. CONCAT Function

It is mainly used for string connection. The specific syntax is as follows:

CONCAT (c1, c2)

Receive two parameters and connect 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 all values are NULL, the function returns NULL.

An example of adding a metaunit for a product price is as follows:

2. NVL Function

This function is mainly used for function replacement.

NVL (e1, e2)

Receives 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 second parameter.

An example is as follows:

Query the related information of the product table. The "no detailed description" is displayed for the default settings of products that are not described in detail"

NULL can be replaced by no detailed description.

There are still many common character functions. I hope you can comment on them based on me.

1 2 3 4 5 Next Page

[Content navigation]
Page 6: character Functions	Page 1: Numeric Functions
Page 1: Date Functions	Page 1: conversion functions
Page 1: Aggregate functions