SELECT "L_HYXM"."HYID",
"L_HYXM"."HYXM",
"L_HYXM"."KSDM",
"L_HYXM"."DJ",
"L_HYXM"."SYXM",
"L_HYXM"."SL",
"L_HYXM"."YLXH",
"L_HYXM"."SRM1",
"L_HYXM"."SRM2",
"L_HYXM"."SRM3",
"L_HYXM"."INUREDATE",
"L_HYXM"."OPERATOR",
"L_HYXM"."FLAG",
"L_HYXM"."NOTE",
"L_HYXM"."DEFRESULT",
"L_HYXM"."EMERGENCY",
"L_HYXM"."SFXM",
"L_HYXM"."XMDH",
"L_HYXM"."XMXH",
"L_HYXM"."YBLX",
"L_HYXM"."BGSJ_DD",
"L_HYXM"."DJSJ_DD",
"L_HYXM"."USEDNOW",
"L_HYXM"."XMLBA",
"L_HYXM"."XMLBB",
"L_HYXM"."SJXMLB",
"L_HYXM"."JBLB",
"L_HYXM"."LCYY",
"L_HYXM"."FHLX",
"L_HYXM"."BQLX",
"L_HYXM"."GBXM",
"L_HYXM"."STBH",
"L_HYXM"."FYMC",
"L_HYXM"."ZHPB",
"L_HYXM"."HISLB",
"L_HYXM"."BBFS",
"L_HYXM"."USENOW",
"L_HYXM"."SHOW_GZ",
"L_HYXM"."SHOW_BG",
"L_HYXM"."ZHLB",
"L_HYXM"."XZKS",
"L_HYXM"."XZLB",
"L_HYXM"."QTZH",
"L_HYXM"."TQBJSJ",
"L_HYXM"."NEEDYY",
"L_HYXM"."JJRXM",
"L_HYXM"."HYXMBM",
"L_HYXM"."LCCSTYPE",
"L_HYXM"."ISCFKD",
"L_HYXM"."CSTC",
"L_HYXM"."CSSM",
"L_HYXM"."SQKD"
FROM "L_HYXM",
"L_TESTDESCRIBE"
WHERE "L_TESTDESCRIBE"."TESTID" IN (:ar_testid) AND "L_HYXM"."USENOW" = 1 AND
"L_HYXM"."YLXH" = "L_TESTDESCRIBE"."YLXH" AND
"L_HYXM"."YLXH" > 0 AND ("L_HYXM"."ZHPB" = 0 OR "L_HYXM"."ZHPB" IS NULL)
你的列名是不是有错误
连接的oracle数据库,列名没有错误。。。。