17,377
社区成员
发帖
与我相关
我的任务
分享
declare
v_test number :=3;
v_mes varchar2(10);
begin
v_mes :=decode(v_test,3,'aaa','fafa');
dbms_output.put_line(v_mes);
end;
declare
v_mes varchar2(10);
begin
v_mes :=to_char(12312);
dbms_output.put_line(v_mes);
end;
declare
v_test number :=3;
v_mes varchar2(10);
begin
select decode(v_test,3,'aaa','fafa') into v_mes from dual;
dbms_output.put_line(v_mes);
end;