1.oracle截取查询结果前几位 2.Oracle查询结果日期格式转化 3.去除头,去除尾 SELECT TRIM(TRAILING ‘/’ from 字段) from 表名; TRIM(BOTH’/’ from 字段)