17,086
社区成员
发帖
与我相关
我的任务
分享
CREATE VIEW VreportSettleAccount
AS
SELECT 记账时间,记账人编号,线上放款,
DECODE(放款方式,1, '线上放款',2 ,'线下放款') 放款方式
FROM VREPAYRECEIPT
CREATE VIEWVreportSettleAccount
AS
SELECT 记账时间,记账人编号,线上放款,
DECODE(放款方式,1, '线上放款',2 ,'线下放款') 放款方式
FROM VREPAYRECEIPT
\
CREATE OR REPLACE VIEW Account
AS
SELECT jzsj
jzr_id,xsfd,xxfd,
sum(xsfd+xxfd),
decode(ffkfs,1, 'xsfd',2 ,'xxfd') ffkfs
FROM VREPAYRECEIPT;
create or replace view v_name
as
select 记账时间,记账人编号,线上放款(数量),线下放款(数量),decode(放款方式,1,线上,2,线下),sum(线上放款+线上放款)from
VREPAYRECEIPT
-- 使用一个 decode 函数
create or replace view VreportSettleAccount
as
select 记账时间,记账人编号,线上放款,
decode(放款方式,1, '线上放款',2 ,'线下放款') 放款方式
from VREPAYRECEIPT
CREATE OR REPLACE VIEW VreportSettleAccount
AS
SELECT 记账时间,
记账人编号,
线上放款(数量),
线下放款(数量),
sum(线上放款+线下放款),
decode(放款方式,1, '线上放款',2 ,'线下放款') 放款方式
FROM VREPAYRECEIPT;