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 vote330 views1 answer
If exist column in table drop sql query mysql
SQL
10 votes320 views2 answers
Forgot my mysql password mac
SQL
0 vote350 views1 answer
Oracle locked objects
SQL
23 votes326 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote393 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote366 views1 answer
C# sql transaction multiple connections
SQL
0 vote326 views1 answer
Prepared statement mysql java delete selected rows
SQL
2 votes389 views1 answer
Sql find not in list
SQL
0 vote320 views1 answer
How to get table current identity value in sql server
SQL
5 votes331 views2 answers
Oracle rename table
SQL