Sql

Search

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'

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql compare two tables for differences
Sql :: renombrar tabla mysql
Sql :: DROP TABLes regardless of constraints
Sql :: datediff in sql server
Sql :: create a view in sqlite
Sql :: mysql case when or
Sql :: create table in microsoft sql server
Sql :: datediff
Sql :: pad zero sql server
Sql :: sql waitfor
Sql :: ms sql print from new line
Sql :: select into temp table
Sql :: mysqldump ignore table
Sql :: select where duplicate mysql
Sql :: sql calculate working days between two dates excluding weekends and holidays
Sql :: mysql between
Sql :: modify column name in sql
Sql :: how to query without duplicate rows in sql
Sql :: postgresql connection string c#
Sql :: 1396(hy00) mysql error
Sql :: install mysql on ubuntu
Sql :: drop column from local database postgres pgadmin
Sql :: how to install sql in anaconda
Sql :: How to pass password to mysql command line
Sql :: sql lag
Sql :: mysql if condition
Sql :: sql distinct only one column
Sql :: how to count number of rows in sql
Sql :: upper case sql
Sql :: show sql server database

Search

SQL

trim sql oracle

ADD CONTENT