PL/SQL以下语句查询视图:
select * from HMCS.HCM_ANDON_HIS_FOR_EAM_V@SHDBTAF1 where
solution_status='未录' and t_time>'2019-6-1 00:00:00' order by t_time desc;
报错:
解决方案:
alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';
PL/SQL以下语句查询视图:
select * from HMCS.HCM_ANDON_HIS_FOR_EAM_V@SHDBTAF1 where
solution_status='未录' and t_time>'2019-6-1 00:00:00' order by t_time desc;
报错:
解决方案:
alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';