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 vote299 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote322 views1 answer
Mysql sql.gz
SQL
3 votes321 views1 answer
Sql online test questions and answers
SQL
4 votes319 views4 answers
Print pl sql
SQL
0 vote362 views1 answer
Sql find gaps in date ranges
SQL
1 vote311 views1 answer
Can not connect to mysql server
SQL
0 vote324 views1 answer
Case insensitive sql
SQL
0 vote325 views1 answer
Sql ignore
SQL
0 vote302 views1 answer
Drop all data from tables
SQL
0 vote355 views1 answer
Consecutive numbers sql
SQL