大家好,我是oracle的新手,刚写个语句但一直提醒错误,请大家帮忙看看SELECT CUS_ID,
DECODE(CUS_NAME, SUBSTR(CUS_NAME, 1, 3) = 'MRS', 'girl', 'man') ANAME
FROM XL_TARGET;
一直提醒ora00907丢失右括号错误
DECODE(CUS_NAME, SUBSTR(CUS_NAME, 1, 3) = 'MRS', 'girl', 'man') ANAME
FROM XL_TARGET;
一直提醒ora00907丢失右括号错误
SELECT CUS_ID,
DECODE(CUS_NAME, SUBSTR(CUS_NAME, 1, 3) , 'MRS', 'girl', 'man') ANAME
FROM XL_TARGET;
DECODE(CUS_NAME, SUBSTR(CUS_NAME, 1, 3) , 'MRS', 'girl', 'man') ANAME
FROM XL_TARGET;
那如果我想根据别的字段的值来判断这个字段的值该怎么写,
我这样写有问题DECODE(cus_name,cus_id,'1001', 'man','girl'),该怎么写'1001' 是cus_id
没看明白你想实现什么意思~~
看楼主的意思是
if ... then ...
elsif ... then ...可以使用oracle的case 表达式select (case when substr(dname,1,3) ='MRS' then 'girl'
else 'man'
end )as d from dept;
或者select (case substr(dname,1,3) when 'MRS' then 'girl'
else 'man'
end )as d from dept;
DECODE(SUBSTR(CUS_NAME, 1, 3) ,'MRS', 'girl', 'man') ANAME
FROM XL_TARGET;
这样吧。