Home

Oracle's join operator (+) should not be used

Rule description

  • Oracle's join operator (+) should not be used

 

Non-compliant Code Example

SELECT
  customer_name,
  od.order_id,
  od.order_date,
  od.total_amount
FROM
	orders od, customers cust
WHERE
	cust.id = od.CustomerId(+) --Non compliant code (Oracle's join operator (+) is used)

Compliant Code Example

SELECT
  customer_name,
  od.order_id,
  od.order_date,
  od.total_amount
FROM
  orders od
LEFT OUTER JOIN customers cust ON cust.id = od.CustomerId; --Compliant code
Visual Expert 2020
 VEPLSQLRULE114