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 vote294 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote282 views1 answer
Drop all tables in azure sql database
SQL
0 vote234 views1 answer
Oracle sql replace string in clob
SQL
0 vote290 views3 answers
Find below average salary in sql
SQL
0 vote313 views1 answer
Sqlalchemy one column of two has to be not null
SQL
-3 votes321 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
0 vote296 views1 answer
Rename view mysql
SQL
0 vote308 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote290 views1 answer
Oracle c# multiple update sql
SQL
1 vote282 views1 answer
Using SQL in rails migration
SQL