ORACLE系列异常总结ORA

拼搏现实的明天。 2022-05-18 02:07 82阅读 0赞

本文对常见的Oracle使用中的异常解决方案进行总结

1.[ORACLE异常--ORA系列：ORA-00904 标识符无效 invalid identifier][ORACLE_--ORA_ORA-00904 _ invalid identifier]

2.[ORACLE异常--ORA-00918 未明确定义列 column ambiguously defined][ORACLE_--ORA-00918 _ column ambiguously defined]

3.[ORA-00942 表或视图不存在 table or view does not exist][ORA-00942 _ table or view does not exist]

4.[ORA-00984 列在此处不允许 SQL parse error location][ORA-00984 _ SQL parse error location]

5.[ORA-01013 报错用户请求取消当前的操作][ORA-01013]

6.[ORA-01741 非法的零长度标识符][ORA-01741]

7.[ORA-01747 或列说明无效 user.table.column, table.column][ORA-01747 _ user.table.column_ table.column]

8.[ORA-01861 文字与格式字符串不匹配][ORA-01861]

9.[ORA-06553 PLS-306][]

10.[ORA-12704 字符集不匹配 character set mismatch][ORA-12704 _ character set mismatch]

11.ORA-12899 value值太大

12.无效的列类型 1111

内容更新中..........................

[ORACLE_--ORA_ORA-00904 _ invalid identifier]: https://blog.csdn.net/baidu_37107022/article/details/80874960
[ORACLE_--ORA-00918 _ column ambiguously defined]: https://blog.csdn.net/baidu_37107022/article/details/81258939
[ORA-00942 _ table or view does not exist]: https://blog.csdn.net/baidu_37107022/article/details/81259092
[ORA-00984 _ SQL parse error location]: https://blog.csdn.net/baidu_37107022/article/details/81259113
[ORA-01013]: https://blog.csdn.net/baidu_37107022/article/details/81259148
[ORA-01741]: https://blog.csdn.net/baidu_37107022/article/details/81259209
[ORA-01747 _ user.table.column_ table.column]: https://blog.csdn.net/baidu_37107022/article/details/81259228
[ORA-01861]: https://blog.csdn.net/baidu_37107022/article/details/81259268
[ORA-06553 PLS-306]: https://blog.csdn.net/baidu_37107022/article/details/81259291
[ORA-12704 _ character set mismatch]: https://blog.csdn.net/baidu_37107022/article/details/81259319