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 vote315 views2 answers
How to combine two sql queries in one result
SQL
0 vote689 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote352 views1 answer
Laravel eloquent get generated sql
SQL
16 votes361 views3 answers
Jwt secret key generator laravel
SQL
0 vote334 views1 answer
Oracle last connection
SQL
0 vote348 views1 answer
Partitioning in oracle-base
SQL
18 votes374 views4 answers
Mysql current date between two dates
SQL
1 vote349 views3 answers
Mysql disable foreign keys check
SQL
4 votes365 views2 answers
How to insert ip address in mysql using php
SQL
0 vote465 views1 answer
Drop table BigQuery table columns
SQL