语法错误WITH site AS ( SELECT 0 isbuoy FROM dual UNION ALL SELECT 1 isbuoy FROM dual UNION ALL SELECT 2 isbuoy FROM dual UNION ALL SELECT 3 isbuoy FROM dual )
select isbuoy ,case when isbuoy = 0 then '集装箱' when isbuoy = 1 then '浮标' when isbuoy = 2 then '固定' else 'N/A' end is_type from site
(
SELECT 0 isbuoy FROM dual
UNION ALL SELECT 1 isbuoy FROM dual
UNION ALL SELECT 2 isbuoy FROM dual
UNION ALL SELECT 3 isbuoy FROM dual
)
select isbuoy
,case when isbuoy = 0 then '集装箱'
when isbuoy = 1 then '浮标'
when isbuoy = 2 then '固定'
else 'N/A' end is_type
from site