what is the meaning of (+) operator in pl/sql eg:- rec.ptp_id= PTP.ptp_id(+) Is it left outer join when we specify (+) in right?
Its outer join ,left outer join
Asked
Active
Viewed 15 times
0
-
I think you answered your own question. Its outer join. If on the left side, left outer join, and if on the right side, right outer join. I think it is not a recommended use anymore though. Still exists for legacy code. – topsail Jan 26 '23 at 20:56
-
Note that this question has already been answer here as well: https://stackoverflow.com/questions/1376442/what-does-do-in-oracle-sql – topsail Jan 26 '23 at 20:57