oracle 如果字段是以特定字符开头的，取另一个值

SELECT (CASE
         WHEN column_name NOT LIKE '特定字符%' THEN '另一个值'
         ELSE column_name
       END) AS result_column
FROM your_table;