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 vote167 views2 answers
Azure sql-datenbank
SQL
0 vote168 views2 answers
Cascade syntax in sql
SQL
0 vote183 views1 answer
How to combine rows in sql server procedure
SQL
1 vote177 views1 answer
Sql select where id not exists in another table
SQL
1 vote153 views1 answer
Foreign key in oracle sql developer
SQL
2 votes188 views2 answers
Spring import sql
SQL
0 vote201 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote182 views1 answer
Case insensitive sql
SQL
-1 vote179 views1 answer
Add column alter table default value
SQL
2 votes177 views2 answers
Mamp connect mysql terminal
SQL