日期:2014-05-17  浏览次数:20858 次

数据怎么了呀?01437、06512
当我输入用户访问数据库对象的时候就报这个错误。请问这个是什么错误?

ORA-01437 无法连接 CONNECT BY
ORA-06512 在 line 84

------解决方案--------------------
start with...connect by层次查询不能同时用于多张表
A join operation was specified with a CONNECT BY clause. If a CONNECT BY clause is used in a SELECT statement for a tree-structured query, only one table may be referenced in the query.
------解决方案--------------------
ORA-01437:cannot have join with CONNECT BY
Cause: A join operation was specified with a CONNECT BY clause. 
If a CONNECT BY clause is used in a SELECT statement for a tree-structured query, 
only one table may be referenced in the query.
Action: Remove either the CONNECT BY clause or the join operation from the SQL statement.