testing on pl/sql developer
/************************/
DECLARE
W_ORDSEQ NUMBER := 5465;
W_ORDNO VARCHAR2(30);
W_TYPE VARCHAR2(30) := 'M001';
BEGIN
EXECUTE IMMEDIATE 'SELECT ORDNO FROM ORD WHERE ORDSEQ = :P_ORDSEQ AND ORDTY=:P_ORDTY' INTO W_ORDNO USING W_ORDSEQ,W_TYPE;
DBMS_OUTPUT.put_LINE(W_ORDNO);
END;
posted on 2009-10-09 14:07
譚明 閱讀(263)
評論(0) 編輯 收藏 所屬分類:
Oracle