oracle去除最后一个字符

 with t_table1 as
(
  select 'sssssssdcc\' as a from dual
  union all
    select 'fscedcea,' as a from dual
)
select  a, substr(a,1,length(a) -1 ) from t_table1