首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > oracle >

数据如何了呀?01437、06512

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

数据怎么了呀?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.

热点排行
Bad Request.