oracle pl/sql 存储过程

Question

编写存储过程保存为 .sql 文件运行，生成按季度分类的汇总销售额报表，包括：季度（标题）、年度、订单数、销售额用逻辑循环编，要怎么写啊

Answer 1

这个是表结构
create table Orders
(
    OrdersID                 number(7)        not null,
    CusID                   varchar2(5),
    EmpID                 number,
    OrderDate                DATE,
    ArrivalDate                 DATE,
    DispatchDate                  DATE,
    Deliverier               varchar2(20),
    Deliveryfee                number(7,2),
    HostName                 varchar2(40),
    HostAddress                 varchar2(60),
    HostCity                 varchar2(25),
    HostArea                 varchar2(25),
    HostPC               varchar2(20),
    HostState                 varchar2(25)
);create table Product
(
    ProID NUMBER not null,
    ProName VARCHAR2(20),
    SupID NUMBER,
    ClassID NUMBER,
    UnitNum VARCHAR2(20),
    Price  number(7,2),
    Stock NUMBER,
    Orders NUMBER,
    Reorders NUMBER,
    Stop VARCHAR2(5) not null
);
create table SaleOrderItem
(
    OrderID                 number,
    ProductID                 number,
    Price                   number(7,2),
    Num                  number,
    Disconut                   number(7,2)
);