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-13703: The snapshot pair [string, string] for database_id string and instance_id string are not found in the current repository.

1 Answers  


ORA-13369: invalid value for etype in the 4-digit format

1 Answers  


TNS-00557: unsupported wallet retrieval method

1 Answers  


PLS-00563: illegal use of CAST expression

1 Answers  


PCB-00525: Use of the AT clause is not permitted here

1 Answers  






PROC-00015: Failed to initialize the cluster registry successfully

1 Answers  


ORA-02334: cannot infer type for column

1 Answers  


ORA-13151: failed to remove exception record

1 Answers  


ORA-32311: materialized view definition query selects an unsupported user-defined type

1 Answers  


ORA-06321: IPA: Cannot reach the remote side

1 Answers  


PLS-00591: this feature is not supported in client-side programs

1 Answers  


RMAN-06207: WARNING: string objects could not be deleted for string channel(s) due

1 Answers  


Categories