web项目中的数据库初始化的字符串拼接问题?
凉城薄梦丶 2017-01-05 08:24:34 unitOfWork.InitializeRepository.ExecuteSqlCommand(@"create materialized view MV_CAPTURE_DAY_TOTAL
refresh force on demand
start with sysdate next to_date( concat( to_char( sysdate+1,'dd-mm-yyyy'),' 01:00:00'),'dd-mm-yyyy hh24:mi:ss')
as
select to_char(t.authtime,'YYYY-MM-DD') as name,count(t.mac) as count
from wifiauth t
where sysdate-t.authtime<15 and t.authtime<to_date(to_char(sysdate,'YYYY-MM-DD'),'YYYY-MM-DD')
group by to_char(t.authtime,'YYYY-MM-DD');
");
以上是初始化过程中的创建物化视图, 调试时copy 出的 ExecuteSqlCommand()的参数值 也就是
create materialized view MV_CAPTURE_DAY_TOTAL
refresh force on demand
start with sysdate next to_date( concat( to_char( sysdate+1,'dd-mm-yyyy'),' 01:00:00'),'dd-mm-yyyy hh24:mi:ss')
as
select to_char(t.authtime,'YYYY-MM-DD') as name,count(t.mac) as count
from wifiauth t
where sysdate-t.authtime<15 and t.authtime<to_date(to_char(sysdate,'YYYY-MM-DD'),'YYYY-MM-DD')
group by to_char(t.authtime,'YYYY-MM-DD');
");
与数据库中的一模一样(本人仔细对比多好多次) 但是运行时,抓异常会提示 无效的字符 的错误。
求大神帮忙, 明天一大早,项目部署要用。