文档解释ORA-22900:theSELECTlistitemofTHEsubqueryisnotacollectiontypeCause:TheTHEsubquerymustSELECTanestedtableorVARRAYitem.Action:changethesubquerytoSELECTanestedta...

文档解释ORA-22817:subquerynotallowedinthedefaultclauseCause:Anattemptwasmadetouseasubqueryinthecolumndefaultclauseexpression.Action:Removethesubqueryfromthedefaultc...

文档解释ORA-02324:morethanonecolumnintheSELECTlistofTHEsubqueryCause:MorethanonecolumnwasselectedintheTHEsubquery.Action:SpecifyonlyonecolumnintheSELECTlistoftheTHE...

文档解释ORA-22818:subqueryexpressionsnotallowedhereCause:Anattemptwasmadetouseasubqueryexpressionwherethesearenotsupported.Action:Rewritethestatementwithoutthesubqu...

文档解释ORA-02251:subquerynotallowedhereCause:Subqueryisnotallowedhereinthestatement.Action:Removethesubqueryfromthestatement.ORA-02251:子查询不允许在当前位置使用。官方解释ORA-02251是...

文档解释ORA-39753:unsupporteduseofsubqueryinPARTITIONEDOUTERJOINconditionCause:AnattemptwasmadetousesubqueryinPARTITIONEDOUTERJOINcondition.Action:Removesubqueryfro...

文档解释ORA-01799:acolumnmaynotbeouter-joinedtoasubqueryCause:(+)()isnotallowed.Action:Eitherremovethe(+)ormakeaviewoutofthesubquery.InV6andbefore,the(+)wasjustigno...

文档解释Errornumber:3973;Symbol:ER_SUBQUERY_TRANSFORM_REJECTED;SQLSTATE:HY000Message:Statementrequiresatransformofasubquerytoanon-SEToperation(likeIN2EXISTS,orsubqu...

文档解释Errornumber:3018;Symbol:ER_NO_FT_MATERIALIZED_SUBQUERY;SQLSTATE:HY000Message:CannotcreateFULLTEXTindexonmaterializedsubqueryErrornumber:3018;Symbol:ER_NO_FT...

http://blog.csdn.net/c517984604/article/details/7052186 [Err]1242-Subqueryreturnsmorethan1row --表示子查询返回了多行数据例如:select*fromtable1wheretable1.colums=(se...