ORA-01799: a column may not be outer-joined to a subquery



ORA-01799: a column may not be outer-joined to a subquery..

Answer / guest

Cause: <expression>(+) <relop> (<subquery>) is not allowed.

Action: Either remove the (+) or make a view out of the
subquery. In V6 and before, the (+) was just ignored in this
case.

Please add more information about this Error

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30568: cannot drop log group - nonexistent log group

1 Answers  


DRG-11847: Revalidation Failed

1 Answers  


ORA-09719: osncui: invalid handle.

1 Answers  


TNS-12598: TNS:banner registration failed

1 Answers  


ORA-38430: Operation "string" not supported in the current release.

1 Answers  






ORA-16570: operation requires restart of database "string"

1 Answers  


ORA-28512: cannot get data dictionary translations from string

1 Answers  


ORA-12002: there is no materialized view log on table "string"."string"

1 Answers  


RMAN-00550: parser package failed to load

1 Answers  


QSM-01021: materialized view, string, not found in the hint list

1 Answers  


ORA-02260: table can have only one primary key

1 Answers  


ORA-24084: DBLINK name in address field of agent string is not unique within the first 24 bytes

1 Answers  


Categories