oracle function

记录的目的在于方便查询

CREATE OR REPLACE FUNCTION F_GET_XX(cat_code_num IN number, --xx
                                             is_parent    in char := null--yy
                                             )
  RETURN VARCHAR2 IS
  
  v_result VARCHAR2(4000);
BEGIN
  BEGIN
    IF is_parent IS NULL THEN
      SELECT xx
        into v_result
        from select 1 from dual;
    ELSE
      SELECT yy
        into v_result
        FROM select 1 from dual
       WHERE ROWNUM = 1;
    END IF;
  EXCEPTION
    WHEN OTHERS THEN
      v_result := NULL;
  END;
  RETURN v_result;
END F_GET_XX;
/