| Function | Description |
|---|---|
| SELECT CHARACTER_LENGTH(Details) FROM Orders; |
Scalar function taking the character or CLOB value in the Details column and returning a numeric value for each row in the Orders table. |
| SELECT AVG(Salary) FROM Employee; |
Aggregate function returning a single numeric value for the group of numeric values specified by the Salary column in the Employee table. |