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 vote119 views1 answer
Postgresql find missing id
SQL
0 vote120 views1 answer
Create bdd mysql
SQL
0 vote125 views1 answer
Write sql query to show the details start from digit
SQL
0 vote203 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote130 views1 answer
Oracle allow space to user
SQL
0 vote121 views2 answers
Sql day from datetime
SQL
0 vote131 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote140 views1 answer
Replace string in whole database mysql stackoverflow
SQL
2 votes126 views1 answer
How to find constraints on a table in oracle
SQL
2 votes121 views2 answers
Get all tables using like
SQL