oracle里如何动态执行字符串,如'2*8*0.2'oracle里如何动态执行字符串,如'2*8*0.2'[解决办法]
DECLARE L_N NUMBER;BEGIN EXECUTE IMMEDIATE 'select ' || '2*8*0.2' || ' FROM dual' INTO L_N; DBMS_OUTPUT.PUT_LINE(L_N);END;/输出: 3.2