Database Management Systems
In Oracle, the TRIM() function allows you to trim characters from the sides of a string.
You can trim leading characters, trailing characters, or both.
By default, it trims white space, but you can optionally specify a different character or characters to trim.
In Oracle, the LTRIM() function allows you to trim the left part of a string. By default, it trims white space, but you can optionally specify a different character or characters to trim.
In Oracle, the RTRIM() function allows you to trim the right part of a string. By default, it trims white space, but you can optionally specify a different character or characters to trim.
If you’re trying to run a multi-line query in SQLcl or SQL*Plus, and you keep getting an error such as “Unknown Command”, but running it in SQL Developer causes no such error, maybe this post will help.
By default, SQLcl and SQL*Plus don’t allow blank lines in SQL statements. However, you can change this with the SET SQLBLANKLINES command.
In Oracle, the SINH() function returns the hyperbolic sine of its argument.
In Oracle, the SIN() function returns the sine of its argument, where the argument is an angle expressed in radians.
This article lists the various aggregation pipeline operators that can be used to return individual date parts from a Date object in MongoDB.
In Oracle, the POWER() function returns its first argument raised to the power of its second argument.
Below are 4 functions that enable you to return the hour from a time value in MariaDB.