ORACLE中%TYPE和%ROWTYPE的使用详解_oracle

DECLARE
  V_ORG_NAME SF_ORG.ORG_NAME%TYPE; --与ORG_NAME类型相同
  V_PARENT_ID SF_ORG.PARENT_ID%TYPE;--与PARENT_ID类型相同
BEGIN
  SELECT ORG_NAME,PARENT_ID INTO V_ORG_NAME,V_PARENT_ID
  FROM SF_ORG SO
  WHERE SO.ORG_ID=&ORG_ID;
  DBMS_OUTPUT.PUT_LINE('部门名称：' || V_ORG_NAME);
  DBMS_OUTPUT.PUT_LINE('上级部门编码：' || TO_CHAR(V_PARENT_ID));
END;

DECLARE
  V_SF_ORG_REC SF_ORG%ROWTYPE; --与SF_ORG表中的各个列相同
BEGIN
  SELECT * INTO V_SF_ORG_REC
  FROM SF_ORG SO
  WHERE SO.ORG_ID=&ORG_ID;
  DBMS_OUTPUT.PUT_LINE('部门ID：' || TO_CHAR(V_SF_ORG_REC.ORG_ID));
  DBMS_OUTPUT.PUT_LINE('部门名称：' || V_SF_ORG_REC.ORG_NAME);
  DBMS_OUTPUT.PUT_LINE('上级部门编码：' || TO_CHAR(V_SF_ORG_REC.PARENT_ID));
END;