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 vote201 views1 answer
Get a list of tables and the primary key
SQL
22 votes195 views4 answers
Show list of users in mysql
SQL
5 votes204 views4 answers
Upload database mysql command line
SQL
0 vote248 views1 answer
Change redo log file size in mysql 5.6
SQL
4 votes191 views2 answers
Linq join
SQL
0 vote198 views1 answer
Set a default value for a column in sqlite
SQL
0 vote207 views1 answer
How to install Firebird
SQL
0 vote210 views1 answer
Mysql change timestamp on update
SQL
2 votes183 views2 answers
Postgresql date at timezone
SQL
1 vote260 views1 answer
Select last row from SQL Table
SQL