CREATE OR REPLACE VIEW FA_OBJECT_ASSETMX AS
select G.account account,
G.currency_debet_amount currency_debet_amount,
G.currency_credit_amount currency_credit_amount,
decode(G.account, '161', G.currency_debet_amount) A,
decode(G.account, '161', G.currency_credit_amount) B,
decode(G.account, '162', G.currency_debet_amount) C,
decode(G.account, '162', G.currency_credit_amount) D,
decode(G.account, '163', G.currency_debet_amount) E,
decode(G.account, '163', G.currency_credit_amount) F,
from VOUCHER_ROW_TAB G
ORA-00936: 缺失表达式
select G.account account,
G.currency_debet_amount currency_debet_amount,
G.currency_credit_amount currency_credit_amount,
decode(G.account, '161', G.currency_debet_amount) A,
decode(G.account, '161', G.currency_credit_amount) B,
decode(G.account, '162', G.currency_debet_amount) C,
decode(G.account, '162', G.currency_credit_amount) D,
decode(G.account, '163', G.currency_debet_amount) E,
decode(G.account, '163', G.currency_credit_amount) F,
from VOUCHER_ROW_TAB G
ORA-00936: 缺失表达式
多了个逗号!应该是:CREATE OR REPLACE VIEW FA_OBJECT_ASSETMX AS
select G.account account,
G.currency_debet_amount currency_debet_amount,
G.currency_credit_amount currency_credit_amount,
decode(G.account, '161', G.currency_debet_amount) A,
decode(G.account, '161', G.currency_credit_amount) B,
decode(G.account, '162', G.currency_debet_amount) C,
decode(G.account, '162', G.currency_credit_amount) D,
decode(G.account, '163', G.currency_debet_amount) E,
decode(G.account, '163', G.currency_credit_amount) F
from VOUCHER_ROW_TAB G
from VOUCHER_ROW_TAB G
F后面多了个,