create or replace procedure P_TEST is
STR VARCHAR2(200);
FLAG VARCHAR2(2);
begin
STR := 'A';
FLAG := '1';
STR := STR || CASE
WHEN FLAG = '2' THEN
'A'
ELSE
'A'
END || 'C';
IF FLAG = '1' THEN
BEGIN
DBMS_OUTPUT.PUT_LINE('修改失败' || STR);
END;
END IF;
end P_TEST;
SELECT 'A' || CASE
WHEN 1 = 2 THEN
'A'
ELSE
'B'
END || 'C'
FROM DUAL;
如果本文章对您有所帮助,您可以动一动您的金手指点个赞吧!!!!