- DECLARE
- V_ORG_NAME SF_ORG.ORG_NAME%TYPE;--与ORG_NAME类型相同 V_PARENT_ID SF_ORG.PARENT_ID%TYPE;--与PARENT_ID类型相同
- BEGIN
- SELECTORG_NAME,PARENT_IDINTO V_ORG_NAME,V_PARENT_ID
- FROM SF_ORG SO
- WHERESO.ORG_ID=&ORG_ID;
- DBMS_OUTPUT.PUT_LINE('部门名称:' || V_ORG_NAME);
- DBMS_OUTPUT.PUT_LINE('上级部门编码:' || TO_CHAR(V_PARENT_ID));
- END;
来源: http://www.bubuko.com/infodetail-1980693.html