select a.lsh lsh,a.xm xm,a.xb xb,a.mz mz,
to_date(to_char(a.djrq,''yyyy-MM-dd''),''yyyy-MM-dd'') djrq,
to_date(to_char(a.csrq,''yyyy-MM-dd''),''yyyy-MM-dd'') csrq,
a.lxdh lxdh, a.sbzl sbzl,a.sbqk sbqk, a.sfzh sfzh FROM T_YYDJXX a
这是我的一段查询语句,可是一运行每次都是报错
报错信息:
[SQL] select a.lsh lsh,a.xm xm,a.xb xb,a.mz mz,
to_date(to_char(a.djrq,''yyyy-MM-dd''),(''yyyy-MM-dd'')) djrq,
to_date(to_char(a.csrq,''yyyy-MM-dd''),(''yyyy-MM-dd'')) csrq,
a.lxdh lxdh, a.sbzl sbzl,a.sbqk sbqk, a.sfzh sfzh FROM T_YYDJXX a
[Err] ORA-00907: missing right parenthesis
它说我缺少括号,但是我检查了很久都没发现少了括号啊Oracleselect
to_date(to_char(a.djrq,''yyyy-MM-dd''),''yyyy-MM-dd'') djrq,
to_date(to_char(a.csrq,''yyyy-MM-dd''),''yyyy-MM-dd'') csrq,
a.lxdh lxdh, a.sbzl sbzl,a.sbqk sbqk, a.sfzh sfzh FROM T_YYDJXX a
这是我的一段查询语句,可是一运行每次都是报错
报错信息:
[SQL] select a.lsh lsh,a.xm xm,a.xb xb,a.mz mz,
to_date(to_char(a.djrq,''yyyy-MM-dd''),(''yyyy-MM-dd'')) djrq,
to_date(to_char(a.csrq,''yyyy-MM-dd''),(''yyyy-MM-dd'')) csrq,
a.lxdh lxdh, a.sbzl sbzl,a.sbqk sbqk, a.sfzh sfzh FROM T_YYDJXX a
[Err] ORA-00907: missing right parenthesis
它说我缺少括号,但是我检查了很久都没发现少了括号啊Oracleselect
a.xm xm,
a.xb xb,
a.mz mz,
to_date(to_char(a.djrq,'yyyy-MM-dd'),'yyyy-MM-dd') djrq,
to_date(to_char(a.csrq,'yyyy-MM-dd'),'yyyy-MM-dd') csrq,
a.lxdh lxdh,
a.sbzl sbzl,
a.sbqk sbqk,
a.sfzh sfzh
FROM T_YYDJXX a