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-14614: List value 'string' specified twice in subpartition 'string'

1 Answers  


ORA-04002: INCREMENT must be a non-zero integer

1 Answers  


ORA-39500: failed to notify CRS of a Startup/Shutdown event for database "string", instance "string" (ignored)

1 Answers  


CLSR-00004: Error encountered at string, category=number, operation=string, OS error=number

1 Answers  


IMP-00057: Warning: Dump file may not contain data of all partitions of this table

1 Answers  






ORA-30185: output too large to fit in the buffer

1 Answers  


AUD-00803: internal error while processing WHERE clause

1 Answers  


NCR-03027: NCRO: No remote service session set up yet.

1 Answers  


ORA-39084: cannot detach job string for user string

1 Answers  


PCC-00114: Length spec required in EXEC SQL VAR statements for VARxxx types

1 Answers  


NID-00137: All datafiles that are not dropped should be readable

1 Answers  


DRG-11844: HTTP Version Not Supported

1 Answers  


Categories