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))

posted @ 2022-10-04 00:15  IT情深  阅读(21)  评论(0编辑  收藏  举报