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 vote84 views1 answer
Clear query cache sql server
SQL
0 vote104 views1 answer
Create table like sql
SQL
1 vote102 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote112 views1 answer
Mssql disable foreign key constraint
SQL
0 vote101 views1 answer
Transaction and commit trong sql server
SQL
0 vote102 views1 answer
Consulta alias con inner join
SQL
2 votes103 views1 answer
How to check if a row is null in sql
SQL
0 vote94 views1 answer
Openquery insert into linked server
SQL
6 votes109 views2 answers
Foreign key sqlite3 python
SQL
0 vote100 views1 answer
Drop specific row postgresql
SQL