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

20 votes356 views4 answers
Sqlite create table if not exists
SQL
0 vote455 views1 answer
Compare strings lexicographically in sql
SQL
4 votes350 views1 answer
Sql group by year
SQL
0 vote356 views1 answer
Mysql date minus 1 day
SQL
1 vote342 views1 answer
Psql connect to another database
SQL
3 votes361 views2 answers
Find string in stored procedure sql server
SQL
0 vote336 views1 answer
Mysql create table like
SQL
1 vote346 views1 answer
Oracle index partition
SQL
0 vote417 views1 answer
Reindexing all tables sql server
SQL
0 vote371 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL