oracle trim函数除去空格

by1314 / 2023-07-20 / 原文

官网语法图

TRIM([ { { LEADING | TRAILING | BOTH }
         [ trim_character ]
       | trim_character
       }
       FROM 
     ]
     trim_source
    )
  • leading:开头字符
  • trailing:结尾字符
  • both:开头和结尾字符
  • trim_character:去除的字符
  • trim_source:修剪源