Trim sql oracle

SELECT TRIM('   Exemple   ') FROM dual;						-- 'Exemple'
SELECT LTRIM('   Exemple   ') FROM dual;					-- 'Exemple   '
SELECT RTRIM('   Exemple   ') FROM dual;					-- '   Exemple'
SELECT TRIM(BOTH 'x' FROM 'xxxExemplexxx') FROM dual;		-- 'Exemple'
SELECT TRIM(LEADING 'x' FROM 'xxxExemplexxx') FROM dual;	-- 'Exemplexxx'
SELECT LTRIM('xxxExemplexxx', 'x') FROM dual;				-- 'Exemplexxx'
SELECT TRIM(TRAILING 'x' FROM 'xxxExemplexxx') FROM dual; 	-- 'xxxExemple'
SELECT RTRIM('xxxExemple', 'x') FROM dual;					-- 'Exemplexxx'

Similar codes

0 vote267 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote258 views1 answer
SQL Server modify_timestamp trigger
SQL
1 vote280 views1 answer
Mysql drop key
SQL
0 vote261 views1 answer
Mysqldump don't drop table
SQL
4 votes261 views1 answer
Oracle user tables
SQL
-1 vote306 views2 answers
Sql search all tables for attributes
SQL
0 vote274 views2 answers
Nested query
SQL
0 vote282 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote282 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
0 vote279 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL