Merlin_Win的博客

1、调用procedure：          v_sql  := 'Begin pkg_name.procedure_name(:in_v1, :in_v2, :out_v1, :out_v2); End;' ;          EXECUTE IMMEDIATE v_sql using in in_value1,in in_value2,out out_value1,out out_

SELECT * FROM (SELECT * FROM o_org WHERE org_name = ‘a’) a START WITH a.org_no = ‘b’ CONNECT BY PRIOR a.org_no = a.p_org_no;