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 vote176 views1 answer
Mysql get 2nd value in comma separated list
SQL
1 vote178 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote195 views1 answer
Update foreign key value in mysql
SQL
1 vote215 views1 answer
Mysql view curren querys
SQL
1 vote199 views1 answer
How to run parallel queries in sql server with entity framework
SQL
0 vote196 views1 answer
Sql ignore
SQL
0 vote148 views1 answer
Mysql workbench search all tables
SQL
0 vote196 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
3 votes175 views2 answers
Find the median in sql
SQL
0 vote193 views2 answers
How to find max and min salary in sql
SQL