Oracle DB – SQL Veri sonunda ve başındaki boşlukların silinmesi

update ser_crm_musteri set FIRMA_UNVANI = RTRIM(FIRMA_UNVANI)

where FIRMA_UNVANI LIKE ‘%   %’

both. If no [remstr] is specified, white spaces are removed.

LTRIM(str): Removes all white spaces from the beginning of the string.

RTRIM(str): Removes all white spaces at the end of the string.

Example 1:

SELECT TRIM(‘   Sample   ’);

Result:

‘Sample’

Example 2:

SELECT LTRIM(‘   Sample   ’);

Result:

‘Sample   ’

Example 3:

SELECT RTRIM(‘   Sample   ’);

Result:

‘   Sample’