大家好,我是oracle的新手,刚写个语句但一直提醒错误,请大家帮忙看看
SELECT CUS_ID,
DECODE(CUS_NAME, SUBSTR(CUS_NAME, 1, 3) = 'MRS', 'girl', 'man') ANAME
FROM XL_TARGET;
一直提醒ora00907丢失右括号错误
------解决方案--------------------
- SQL code
--如果cus_name 前三位是MRS的话就显示 girl 否则 man ?SELECT CUS_ID, DECODE(SUBSTR(CUS_NAME, 1, 3),'MRS', 'girl', 'man') ANAME FROM XL_TARGET;
------解决方案--------------------
DECODE语法有问题