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

9 votes360 views6 answers
Replace sql
SQL
3 votes312 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote336 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote355 views1 answer
Postgres select from values
SQL
3 votes352 views2 answers
Mysql user permission database
SQL
-1 vote345 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote367 views1 answer
Sqlite3_open_v2
SQL
38 votes444 views6 answers
Ubuntu install mysql client
SQL
0 vote371 views1 answer
Select sql in descending order
SQL
0 vote356 views1 answer
Mysql 8 error on identified by
SQL