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
谭明 阅读(257)
评论(0) 编辑 收藏 所属分类:
Oracle