如何更改oracle账号oracle中trim函数和replace函数的用法

oracle中trim函数和replace函数的用法

For example:

trim('   tech   ')  would return 'tech'

trim(' '  from  '   tech   ')  would return 'tech'

trim(leading '0' from '000123')  would return '123'

trim(trailing '1' from 'Tech1')  would returnoracle账号 'Tech'

trim(both '1' from '123Tech111')  would return '23Tech'

–chr(10)是换行符，

    –chr(13)是回车，

    –replace(replace(tableSource,CHR(10),''),chr(13),'');