oracle sql if条件则选择statement1 else select statement2

您可以使用

CURSOR

PRINT

VARIABLE prmtr VARCHAR2EXEC :PRMTR := 'A'  -- SET values of parameterVARIABLE x refcursor -- a cursor variableDECLAREBEGIN    IF :PRMTR = 'A' THEN      OPEN :x FOR        SELECt *        FROM   employees;    ELSE      OPEN :x FOR        SELECt *        FROM   departments;    END IF;END;/PRINT x  -- gives you the result of the query.