世间的喧闹都是浮云，书中的宁静才是永恒！！！

create or replace type zmd_member_price_temple_OBj as object(procode varchar2(500),memberprice number(8,2)); create type zmd_member_price_temple as table of zmd_member_price_temple_OBj; create or

create or replace procedure ZMD_GIFCONVERT(p_productcode  varchar2,                                             p_storecode    varchar2,                                             p_qty          in

SELECT ZSD.DEPTID,ZSD.DEPTCODE,ZSD.DEPTDESCR,ZSD.DEPTPID FROM ZMD_SYS_DEPT ZSD  CONNECT BY PRIOR ZSD.DEPTPID  = ZSD.DEPTID START WITH ZSD.DEPTCODE='FACTORY'

http://school.itzcn.com/video-vid-1222-spid-35.html