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 vote180 views1 answer
How to create a new db from dumb file mysql
SQL
13 votes177 views4 answers
What is sql
SQL
8 votes225 views2 answers
Change name of colum in sql table
SQL
0 vote181 views2 answers
Athena drop partition
SQL
0 vote167 views1 answer
How to reset the database value in SQL server
SQL
21 votes213 views3 answers
Average sql
SQL
2 votes181 views1 answer
Node and mysql like
SQL
0 vote164 views1 answer
Install mysql 8 linux
SQL
0 vote186 views1 answer
Sql show founctions
SQL
0 vote162 views1 answer
Sql inserted
SQL