创建一个视图

CREATE OR REPLACE VIEW JYDWZD AS
SELECT F_CODE AS F_DWBH,F_STJC AS F_DWMC,F_STMC AS F_DWMCA,F_JS,F_MX,F_GSXZ,F_GSDM,F_LRZX,F_CODE,F_BKBH,F_BWB,F_NBBH,F_WLDW,F_ZJDW,F_ZJCODE,F_CWCCODE,F_ZJLX,F_KJZG,F_JYCH,F_RJLX,F_DXPZ,F_QSRQ,F_ZZRQ,F_CRDATE,F_CHDATE,UNIT_ID
FROM ACZRZX WHERE F_TRUE = '1'
ORDER BY F_CODE;

转载于:https://www.cnblogs.com/cyz110/p/6256551.html