在存储过程中这句:
select sDateTime from t_TableName where EntityID='123' and trunc(to_number(substr(sDateTime,11,2))/15=1)字段sDateTime是varchar类型,编译后提示:
Warning(30,188): PLW-07204: 从列类型转换为其它类型可能会产生子优化查询计划问:
1、这个警告有什么影响?
2、如何消除这个警告?oracle PLW-07204
select sDateTime from t_TableName where EntityID='123' and trunc(to_number(substr(sDateTime,11,2))/15=1)字段sDateTime是varchar类型,编译后提示:
Warning(30,188): PLW-07204: 从列类型转换为其它类型可能会产生子优化查询计划问:
1、这个警告有什么影响?
2、如何消除这个警告?oracle PLW-07204
where trunc(to_number(substr(sDateTime, 11, 2)) / 15) = 1;
select sDateTime from t_TableName where EntityID='123' and trunc(to_number(substr(sDateTime,11,2))/15)=1同问