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 vote289 views1 answer
Sql where time stamp is in between
SQL
6 votes308 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote328 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote281 views1 answer
Suse start MySQL
SQL
0 vote297 views1 answer
Difference between varchar and varchar2
SQL
1 vote308 views1 answer
Psql autocomplete for mac brew install
SQL
6 votes379 views3 answers
What is where in sql
SQL
0 vote294 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote308 views1 answer
Select 1 from orders
SQL
9 votes327 views4 answers
Mysql set id auto increment
SQL