唉，痛苦死了，
对了一下午，
尽是对这种东西，
想不晕都不行，
我不活了算了。

SELECT dbo.SSE_RATION_STOCK.ZQDM AS SEC_CD,
dbo.SSE_RATION_STOCK.GQDJR AS RGTREG_DT, NULL AS LUDWRT_CD, NULL
AS LUDWRT_NM, dbo.COMPANY_RATION_STOCK.PEIGUND AS DST_YR,
dbo.SSE_RATION_STOCK.JKQSRQ AS PURCH_FDT,
dbo.SSE_RATION_STOCK.JKJZRQ AS PURCH_EDT,
dbo.SSE_RATION_STOCK.QZQSJYRQ AS TRD_FDT,
dbo.SSE_RATION_STOCK.QZJZJYRQ AS TRD_EDT,
dbo.COMPANY_RATION_STOCK.SHISHIFAGBSJ AS PBSH_DT, NULL AS AUTHTXT_ID,
dbo.COMPANY_RATION_STOCK.PEIGUSYL AS DSTSHR_PE,
dbo.SSE_RATION_STOCK.LTGLLPGS + dbo.SSE_RATION_STOCK.FLTGLLPGS AS THDST_TSHR,
dbo.SSE_RATION_STOCK.PGLLZJE AS DSTTH_TCAP,
dbo.SSE_RATION_STOCK.LTGLLPGS AS CIR_TSHR,
dbo.SSE_RATION_STOCK.FLTGLLPGS AS UCIR_TSHR,
dbo.SSE_RATION_STOCK.LLZPS AS THCNV_QTY,
dbo.SSE_RATION_STOCK.LLZZPS AS THA3_QTY,
dbo.COMPANY_RATION_STOCK.SHIJIPGJG AS ACTDST_PRC,
dbo.COMPANY_RATION_STOCK.SHIJIPGBL AS ACTDST_RTO,
dbo.SSE_RATION_STOCK.ZPBL AS CONV_RTO,
dbo.SSE_RATION_STOCK.SJPGS AS ACTDST_SHR,
dbo.SSE_RATION_STOCK.LTGPGS AS CRDST_AQTY,
dbo.SSE_RATION_STOCK.FLTGPGS AS UCDST_AQTY,
dbo.SSE_RATION_STOCK.SJZPGS AS ACTCNV_SHR,
dbo.SSE_RATION_STOCK.SJZZPGS AS ACTA3_SHR,
dbo.COMPANY_RATION_STOCK.SHIJICJJJ * 10000 AS ACT_RCAP,
dbo.COMPANY_RATION_STOCK.DAGUDRGZHJE * 10000 AS ASTPCH_AMT,
dbo.COMPANY_RATION_STOCK.DAGUDRGZCNR AS ASTPCH_TXT,
dbo.SSE_RATION_STOCK.CQR AS EXRGT_DT,
dbo.SSE_RATION_STOCK.CQQLR AS BFXRGT_PRF,
dbo.SSE_RATION_STOCK.CQHLR AS AFXRGT_PRF,
dbo.SSE_RATION_STOCK.CQQJG AS BFXRGT_PRC,
dbo.SSE_RATION_STOCK.CQHJG AS AFXRGT_PRC,
dbo.SSE_RATION_STOCK.A1PQDM AS WRNT_CD,
dbo.SSE_RATION_STOCK.A1PQJC AS WRNT_SNM,
dbo.SSE_RATION_STOCK.A2PQDM AS A2WRNT_CD,
dbo.SSE_RATION_STOCK.A2PQJC AS A2WRNT_SNM,
dbo.SSE_RATION_STOCK.A3PQDM AS A3WRNT_CD,
dbo.SSE_RATION_STOCK.A3PQJC AS A3WRNT_SNM,
dbo.SSE_RATION_STOCK.BGCKJ AS BSHROP_PRC, NULL AS CAP_AMT, NULL
AS UDWRT_TEXP,
dbo.COMPANY_RATION_STOCK.CHENGXIAOFY * 10000 AS UDWRT_EXP,
dbo.COMPANY_RATION_STOCK.ZHUCEKJSFY * 10000 AS RVW_EXP,
dbo.COMPANY_RATION_STOCK.LUSHIFY * 10000 AS ATTNY_EXP,
dbo.COMPANY_RATION_STOCK.SHANGSHIGGGBRQ AS DSHRLST_DT,
dbo.SSE_RATION_STOCK.PGSSRQ AS SHRLST_DT,
dbo.SSE_RATION_STOCK.LTGPGS - dbo.SSE_RATION_STOCK.SSDJS AS CURLST_QTY,
dbo.SSE_RATION_STOCK.SSDJS AS LSTFRZ_QTY,
dbo.COMPANY_RATION_STOCK.SHISHIFANR AS DSTPLN_TXT, NULL
AS UDWRT_TYP,
dbo.COMPANY_RATION_STOCK.CHENGXIAOSBXSL AS UDCIR_SHR, NULL
AS UDUCIR_SHR, NULL AS ATTNY_CD, NULL AS ACCT_CD
FROM dbo.COMPANY_RATION_STOCK INNER JOIN
dbo.SSE_RATION_STOCK ON SUBSTRING(dbo.COMPANY_RATION_STOCK.JIGOUBM,
6, 11) = dbo.SSE_RATION_STOCK.ZQDM

晕了~`晕了~`晕了~`

janlay在上个帖子中说

引用:

---

适当地用一下小写字母，可以减轻心理压力 :)

---

值得考虑的建议啊。

不妨让你们见识见识下这种东西，
这就是偶前段时间搞的触发器中的一个，
我能活下来真是万幸啊。

create or replace trigger TRG_LOG_2 BEFORE UPDATE OR DELETE ON SECURITIES_COMPANY_INFO_NEW FOR EACH ROW
DECLARE v_PKvalue VARCHAR2(2000);BEGIN IF UPDATING THEN IF :old.caibiangxbz='0' AND :new.caibiangxbz <> '1' AND ((:old.JIGOUBM<>:new.JIGOUBM OR (:old.JIGOUBM IS NULL AND :new.JIGOUBM IS NOT NULL) OR (:old.JIGOUBM IS NOT NULL AND :new.JIGOUBM IS NULL)) OR (:old.QUANSHANGMC<>:new.QUANSHANGMC OR (:old.QUANSHANGMC IS NULL AND :new.QUANSHANGMC IS NOT NULL) OR (:old.QUANSHANGMC IS NOT NULL AND :new.QUANSHANGMC IS NULL)) OR (:old.JIEZHIRQ<>:new.JIEZHIRQ OR (:old.JIEZHIRQ IS NULL AND :new.JIEZHIRQ IS NOT NULL) OR (:old.JIEZHIRQ IS NOT NULL AND :new.JIEZHIRQ IS NULL)) OR (:old.QUANSHANGJC<>:new.QUANSHANGJC OR (:old.QUANSHANGJC IS NULL AND :new.QUANSHANGJC IS NOT NULL) OR (:old.QUANSHANGJC IS NOT NULL AND :new.QUANSHANGJC IS NULL)) OR (:old.YINGWENMC<>:new.YINGWENMC OR (:old.YINGWENMC IS NULL AND :new.YINGWENMC IS NOT NULL) OR (:old.YINGWENMC IS NOT NULL AND :new.YINGWENMC IS NULL)) OR (:old.SHIFOUWZGSBM<>:new.SHIFOUWZGSBM OR (:old.SHIFOUWZGSBM IS NULL AND :new.SHIFOUWZGSBM IS NOT NULL) OR (:old.SHIFOUWZGSBM IS NOT NULL AND :new.SHIFOUWZGSBM IS NULL)) OR (:old.SHIFOUWZGS<>:new.SHIFOUWZGS OR (:old.SHIFOUWZGS IS NULL AND :new.SHIFOUWZGS IS NOT NULL) OR (:old.SHIFOUWZGS IS NOT NULL AND :new.SHIFOUWZGS IS NULL)) OR (:old.CENGYONGMC<>:new.CENGYONGMC OR (:old.CENGYONGMC IS NULL AND :new.CENGYONGMC IS NOT NULL) OR (:old.CENGYONGMC IS NOT NULL AND :new.CENGYONGMC IS NULL)) OR (:old.GENGMINGSJ<>:new.GENGMINGSJ OR (:old.GENGMINGSJ IS NULL AND :new.GENGMINGSJ IS NOT NULL) OR (:old.GENGMINGSJ IS NOT NULL AND :new.GENGMINGSJ IS NULL)) OR (:old.GENGMINGQZQK<>:new.GENGMINGQZQK OR (:old.GENGMINGQZQK IS NULL AND :new.GENGMINGQZQK IS NOT NULL) OR (:old.GENGMINGQZQK IS NOT NULL AND :new.GENGMINGQZQK IS NULL)) OR (:old.FADINGDBR<>:new.FADINGDBR OR (:old.FADINGDBR IS NULL AND :new.FADINGDBR IS NOT NULL) OR (:old.FADINGDBR IS NOT NULL AND :new.FADINGDBR IS NULL)) OR (:old.DONGSHIZ<>:new.DONGSHIZ OR (:old.DONGSHIZ IS NULL AND :new.DONGSHIZ IS NOT NULL) OR (:old.DONGSHIZ IS NOT NULL AND :new.DONGSHIZ IS NULL)) OR (:old.ZONGJINGL<>:new.ZONGJINGL OR (:old.ZONGJINGL IS NULL AND :new.ZONGJINGL IS NOT NULL) OR (:old.ZONGJINGL IS NOT NULL AND :new.ZONGJINGL IS NULL)) OR (:old.GONGSIDM<>:new.GONGSIDM OR (:old.GONGSIDM IS NULL AND :new.GONGSIDM IS NOT NULL) OR (:old.GONGSIDM IS NOT NULL AND :new.GONGSIDM IS NULL)) OR (:old.DIANHUAQH<>:new.DIANHUAQH OR (:old.DIANHUAQH IS NULL AND :new.DIANHUAQH IS NOT NULL) OR (:old.DIANHUAQH IS NOT NULL AND :new.DIANHUAQH IS NULL)) OR (:old.GONGSIDH<>:new.GONGSIDH OR (:old.GONGSIDH IS NULL AND :new.GONGSIDH IS NOT NULL) OR (:old.GONGSIDH IS NOT NULL AND :new.GONGSIDH IS NULL)) OR (:old.GONGSICZ<>:new.GONGSICZ OR (:old.GONGSICZ IS NULL AND :new.GONGSICZ IS NOT NULL) OR (:old.GONGSICZ IS NOT NULL AND :new.GONGSICZ IS NULL)) OR (:old.DIANZIXX<>:new.DIANZIXX OR (:old.DIANZIXX IS NULL AND :new.DIANZIXX IS NOT NULL) OR (:old.DIANZIXX IS NOT NULL AND :new.DIANZIXX IS NULL)) OR (:old.GONGSIWZ<>:new.GONGSIWZ OR (:old.GONGSIWZ IS NULL AND :new.GONGSIWZ IS NOT NULL) OR (:old.GONGSIWZ IS NOT NULL AND :new.GONGSIWZ IS NULL)) OR (:old.CHENGLIRQ<>:new.CHENGLIRQ OR (:old.CHENGLIRQ IS NULL AND :new.CHENGLIRQ IS NOT NULL) OR (:old.CHENGLIRQ IS NOT NULL AND :new.CHENGLIRQ IS NULL)) OR (:old.ZHUCEZB<>:new.ZHUCEZB OR (:old.ZHUCEZB IS NULL AND :new.ZHUCEZB IS NOT NULL) OR (:old.ZHUCEZB IS NOT NULL AND :new.ZHUCEZB IS NULL)) OR (:old.BIZHONG1BM<>:new.BIZHONG1BM OR (:old.BIZHONG1BM IS NULL AND :new.BIZHONG1BM IS NOT NULL) OR (:old.BIZHONG1BM IS NOT NULL AND :new.BIZHONG1BM IS NULL)) OR (:old.BIZHONG1<>:new.BIZHONG1 OR (:old.BIZHONG1 IS NULL AND :new.BIZHONG1 IS NOT NULL) OR (:old.BIZHONG1 IS NOT NULL AND :new.BIZHONG1 IS NULL)) OR (:old.CHENGLISZCZB<>:new.CHENGLISZCZB OR (:old.CHENGLISZCZB IS NULL AND :new.CHENGLISZCZB IS NOT NULL) OR (:old.CHENGLISZCZB IS NOT NULL AND :new.CHENGLISZCZB IS NULL)) OR (:old.BIZHONG2BM<>:new.BIZHONG2BM OR (:old.BIZHONG2BM IS NULL AND :new.BIZHONG2BM IS NOT NULL) OR (:old.BIZHONG2BM IS NOT NULL AND :new.BIZHONG2BM IS NULL)) OR (:old.BIZHONG2<>:new.BIZHONG2 OR (:old.BIZHONG2 IS NULL AND :new.BIZHONG2 IS NOT NULL) OR (:old.BIZHONG2 IS NOT NULL AND :new.BIZHONG2 IS NULL)) OR (:old.ZHUCEZBBDRQ<>:new.ZHUCEZBBDRQ OR (:old.ZHUCEZBBDRQ IS NULL AND :new.ZHUCEZBBDRQ IS NOT NULL) OR (:old.ZHUCEZBBDRQ IS NOT NULL AND :new.ZHUCEZBBDRQ IS NULL)) OR (:old.ZHUCEGJ<>:new.ZHUCEGJ OR (:old.ZHUCEGJ IS NULL AND :new.ZHUCEGJ IS NOT NULL) OR (:old.ZHUCEGJ IS NOT NULL AND :new.ZHUCEGJ IS NULL)) OR (:old.SUOZAISQBM<>:new.SUOZAISQBM OR (:old.SUOZAISQBM IS NULL AND :new.SUOZAISQBM IS NOT NULL) OR (:old.SUOZAISQBM IS NOT NULL AND :new.SUOZAISQBM IS NULL)) OR (:old.SUOZAISQ<>:new.SUOZAISQ OR (:old.SUOZAISQ IS NULL AND :new.SUOZAISQ IS NOT NULL) OR (:old.SUOZAISQ IS NOT NULL AND :new.SUOZAISQ IS NULL)) OR (:old.SUOZAICS<>:new.SUOZAICS OR (:old.SUOZAICS IS NULL AND :new.SUOZAICS IS NOT NULL) OR (:old.SUOZAICS IS NOT NULL AND :new.SUOZAICS IS NULL)) OR (:old.YOUZHENGBM<>:new.YOUZHENGBM OR (:old.YOUZHENGBM IS NULL AND :new.YOUZHENGBM IS NOT NULL) OR (:old.YOUZHENGBM IS NOT NULL AND :new.YOUZHENGBM IS NULL)) OR (:old.ZHUCEDZ<>:new.ZHUCEDZ OR (:old.ZHUCEDZ IS NULL AND :new.ZHUCEDZ IS NOT NULL) OR (:old.ZHUCEDZ IS NOT NULL AND :new.ZHUCEDZ IS NULL)) OR (:old.BANGONGDZ<>:new.BANGONGDZ OR (:old.BANGONGDZ IS NULL AND :new.BANGONGDZ IS NOT NULL) OR (:old.BANGONGDZ IS NOT NULL AND :new.BANGONGDZ IS NULL)) OR (:old.YINGYEWDS<>:new.YINGYEWDS OR (:old.YINGYEWDS IS NULL AND :new.YINGYEWDS IS NOT NULL) OR (:old.YINGYEWDS IS NOT NULL AND :new.YINGYEWDS IS NULL)) OR (:old.ZHENGQUANYYBSL<>:new.ZHENGQUANYYBSL OR (:old.ZHENGQUANYYBSL IS NULL AND :new.ZHENGQUANYYBSL IS NOT NULL) OR (:old.ZHENGQUANYYBSL IS NOT NULL AND :new.ZHENGQUANYYBSL IS NULL)) OR (:old.ZHENGQUANFWBSL<>:new.ZHENGQUANFWBSL OR (:old.ZHENGQUANFWBSL IS NULL AND :new.ZHENGQUANFWBSL IS NOT NULL) OR (:old.ZHENGQUANFWBSL IS NOT NULL AND :new.ZHENGQUANFWBSL IS NULL)) OR (:old.XIWEISL<>:new.XIWEISL OR (:old.XIWEISL IS NULL AND :new.XIWEISL IS NOT NULL) OR (:old.XIWEISL IS NOT NULL AND :new.XIWEISL IS NULL)) OR (:old.SHANGJIAOSXWSL<>:new.SHANGJIAOSXWSL OR (:old.SHANGJIAOSXWSL IS NULL AND :new.SHANGJIAOSXWSL IS NOT NULL) OR (:old.SHANGJIAOSXWSL IS NOT NULL AND :new.SHANGJIAOSXWSL IS NULL)) OR (:old.YINGYEZZHM<>:new.YINGYEZZHM OR (:old.YINGYEZZHM IS NULL AND :new.YINGYEZZHM IS NOT NULL) OR (:old.YINGYEZZHM IS NOT NULL AND :new.YINGYEZZHM IS NULL)) OR (:old.YEWUXKZH<>:new.YEWUXKZH OR (:old.YEWUXKZH IS NULL AND :new.YEWUXKZH IS NOT NULL) OR (:old.YEWUXKZH IS NOT NULL AND :new.YEWUXKZH IS NULL)) OR (:old.ZHUYINGYW<>:new.ZHUYINGYW OR (:old.ZHUYINGYW IS NULL AND :new.ZHUYINGYW IS NOT NULL) OR (:old.ZHUYINGYW IS NOT NULL AND :new.ZHUYINGYW IS NULL)) OR (:old.JINGYINGFW<>:new.JINGYINGFW OR (:old.JINGYINGFW IS NULL AND :new.JINGYINGFW IS NOT NULL) OR (:old.JINGYINGFW IS NOT NULL AND :new.JINGYINGFW IS NULL)) OR (:old.GONGSIJYLBBM<>:new.GONGSIJYLBBM OR (:old.GONGSIJYLBBM IS NULL AND :new.GONGSIJYLBBM IS NOT NULL) OR (:old.GONGSIJYLBBM IS NOT NULL AND :new.GONGSIJYLBBM IS NULL)) OR (:old.GONGSIJYLB<>:new.GONGSIJYLB OR (:old.GONGSIJYLB IS NULL AND :new.GONGSIJYLB IS NOT NULL) OR (:old.GONGSIJYLB IS NOT NULL AND :new.GONGSIJYLB IS NULL)) OR (:old.SHENJIAOSHYDM<>:new.SHENJIAOSHYDM OR (:old.SHENJIAOSHYDM IS NULL AND :new.SHENJIAOSHYDM IS NOT NULL) OR (:old.SHENJIAOSHYDM IS NOT NULL AND :new.SHENJIAOSHYDM IS NULL)) OR (:old.SHANGJIAOSHYDM<>:new.SHANGJIAOSHYDM OR (:old.SHANGJIAOSHYDM IS NULL AND :new.SHANGJIAOSHYDM IS NOT NULL) OR (:old.SHANGJIAOSHYDM IS NOT NULL AND :new.SHANGJIAOSHYDM IS NULL)) OR (:old.GONGSIXZBM<>:new.GONGSIXZBM OR (:old.GONGSIXZBM IS NULL AND :new.GONGSIXZBM IS NOT NULL) OR (:old.GONGSIXZBM IS NOT NULL AND :new.GONGSIXZBM IS NULL)) OR (:old.GONGSIXZ<>:new.GONGSIXZ OR (:old.GONGSIXZ IS NULL AND :new.GONGSIXZ IS NOT NULL) OR (:old.GONGSIXZ IS NOT NULL AND :new.GONGSIXZ IS NULL)) OR (:old.YIEWUZGBM<>:new.YIEWUZGBM OR (:old.YIEWUZGBM IS NULL AND :new.YIEWUZGBM IS NOT NULL) OR (:old.YIEWUZGBM IS NOT NULL AND :new.YIEWUZGBM IS NULL)) OR (:old.YIEWUZG<>:new.YIEWUZG OR (:old.YIEWUZG IS NULL AND :new.YIEWUZG IS NOT NULL) OR (:old.YIEWUZG IS NOT NULL AND :new.YIEWUZG IS NULL)) OR (:old.YEWUZGBDQK<>:new.YEWUZGBDQK OR (:old.YEWUZGBDQK IS NULL AND :new.YEWUZGBDQK IS NOT NULL) OR (:old.YEWUZGBDQK IS NOT NULL AND :new.YEWUZGBDQK IS NULL)) OR (:old.ZHUCHENGXZGBM<>:new.ZHUCHENGXZGBM OR (:old.ZHUCHENGXZGBM IS NULL AND :new.ZHUCHENGXZGBM IS NOT NULL) OR (:old.ZHUCHENGXZGBM IS NOT NULL AND :new.ZHUCHENGXZGBM IS NULL)) OR (:old.ZHUCHENGXZG<>:new.ZHUCHENGXZG OR (:old.ZHUCHENGXZG IS NULL AND :new.ZHUCHENGXZG IS NOT NULL) OR (:old.ZHUCHENGXZG IS NOT NULL AND :new.ZHUCHENGXZG IS NULL)) OR (:old.ZHUCHENGXZGPZRQ<>:new.ZHUCHENGXZGPZRQ OR (:old.ZHUCHENGXZGPZRQ IS NULL AND :new.ZHUCHENGXZGPZRQ IS NOT NULL) OR (:old.ZHUCHENGXZGPZRQ IS NOT NULL AND :new.ZHUCHENGXZGPZRQ IS NULL)) OR (:old.GONGSIJJ<>:new.GONGSIJJ OR (:old.GONGSIJJ IS NULL AND :new.GONGSIJJ IS NOT NULL) OR (:old.GONGSIJJ IS NOT NULL AND :new.GONGSIJJ IS NULL)) OR (:old.BEIZHU<>:new.BEIZHU OR (:old.BEIZHU IS NULL AND :new.BEIZHU IS NOT NULL) OR (:old.BEIZHU IS NOT NULL AND :new.BEIZHU IS NULL)) OR 1<>1) THEN :new.caibiangxbz:='2'; END IF;ELSE IF :old.caibiangxbz='0' OR :old.caibiangxbz='2' THEN v_PKvalue:='JIGOUBM='''||:old.JIGOUBM||''' AND 1=1';INSERT INTO sys_table_log@devdb(biaoming,zhujianzhi,caozuobiaozhi) valueS('SECURITIES_COMPANY_INFO_NEW',v_PKvalue,'4'); END IF; END IF;END;

唉，
要有心理准备啊……