ORA-00906 原因:ORALCE Cast强制类型转换如果 as类型为Varchar2必须指定长度
错误写法:
Cast(a.iNum as varchar)
Cast(a.iNum as varchar2)
报错类型:
> ORA-00906: missing left parenthesis
正确写法(指定长度):
Cast(a.iNum as varchar2(38))
本文来自博客园,作者:IT情深,转载请注明原文链接:https://www.cnblogs.com/wh445306/p/16751864.html