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 vote174 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote164 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
0 vote185 views1 answer
Mysql grant all on all databases
SQL
17 votes187 views4 answers
Show tables sql server
SQL
3 votes126 views2 answers
Mysql sum with condition
SQL
0 vote173 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote176 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
0 vote165 views4 answers
Sql year
SQL
2 votes173 views1 answer
Set username and password for postgresql database
SQL
0 vote165 views2 answers
Getting customers with no orders sql
SQL