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

2 votes164 views4 answers
Mysql change database character set to utf8mb4
SQL
65 votes337 views6 answers
Sql add column to table
SQL
0 vote202 views1 answer
How to get data between a last week in mysql
SQL
2 votes221 views1 answer
Mysql now format
SQL
0 vote205 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote202 views2 answers
Getting customers with no orders sql
SQL
0 vote209 views1 answer
Best sql collation
SQL
18 votes201 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote205 views1 answer
Mysql multiple group by
SQL
0 vote193 views1 answer
Access refused mysql xampp server
SQL