在家帮我看一下这两个有什么不同?? CREATE OR REPLACE package optus_report as type myrctype is ref cursor return DSP_TYPE%ROWTYPE; procedure dl_get_demono(p_company_no NUMBER,rc OUT myrctype) ; end optus_report; CREATE OR REPLACE package body optus_report as procedure dl_get_demono(p_company_no IN NUMBER,rc OUT myrctype) as begin open rc for select * from DSP_TYPE where LANG_ID=p_company_no ; end; end optus_report; 和 CREATE OR REPLACE package optus_report as type myrctype_11 IS record( LANG_ID1 NUMBER(2), DATA_TYPE1 CHAR(1), DESCRIPTION1 VARCHAR2(20) ); type myrctype is ref cursor return myrctype_11; procedure dl_get_demono(p_company_no NUMBER,rc OUT myrctype) ; end optus_report; CREATE OR REPLACE package body optus_report as procedure dl_get_demono(p_company_no IN NUMBER,rc OUT myrctype) as begin open rc for select * from DSP_TYPE where LANG_ID=p_company_no ; end; end optus_report;
CREATE OR REPLACE package optus_report as
type myrctype is ref cursor return DSP_TYPE%ROWTYPE;
procedure dl_get_demono(p_company_no NUMBER,rc OUT myrctype) ;
end optus_report;
CREATE OR REPLACE package body optus_report as
procedure dl_get_demono(p_company_no IN NUMBER,rc OUT myrctype) as
begin
open rc for select * from DSP_TYPE where LANG_ID=p_company_no ;
end;
end optus_report;
和
CREATE OR REPLACE package optus_report as
type myrctype_11 IS record(
LANG_ID1 NUMBER(2),
DATA_TYPE1 CHAR(1),
DESCRIPTION1 VARCHAR2(20)
);
type myrctype is ref cursor return myrctype_11;
procedure dl_get_demono(p_company_no NUMBER,rc OUT myrctype) ;
end optus_report;
CREATE OR REPLACE package body optus_report as
procedure dl_get_demono(p_company_no IN NUMBER,rc OUT myrctype) as
begin
open rc for select * from DSP_TYPE where LANG_ID=p_company_no ;
end;
end optus_report;
DATA_TYPE1 CHAR(1),
DESCRIPTION1 VARCHAR2(20)
几个列