Listparts of Oracle Functions

Listparts of Oracle Functions

Recently, I found an interesting Oracle function that can splice column values. Next, let's take a look at its specific usage.

Usage:

The official document explains its role as follows:

For a specified measure,ListpartsOrders data within each group specified inORDER BYClause and then concatenates the values of the measure column.

In each group, listparts sorts column planting according to the order by clause and Concatenates the sorted results.

Measure_expr: Any column-based expression.

Delimiter: delimiter. The default value is NUL.

Order_by_clause: the order by clause determines the order in which column values are spliced.

Through this usage, we can see that the listparts function can be used not only as a common function, but also as an analysis function.

The usage of order_by_clause and query_partition_clause is as follows:

The following is an example of this function:

A common function that sorts wages and concatenates them with commas.

SQL>