Here is a portion of an Informix SQL statement I am being asked to translate for use with an Oracle 9i database:
,OUTER PROVIDER PROV1))
Now then, Oracle 9i can use outer-join syntax in the FROM clause (previous Oracle versions could not). But the Oracle 9i outer-join syntax seems to require that one knows whether or not a left or right outer join is required – the three options are RIGHT OUTER JOIN, LEFT OUTER JOIN, and FULL OUTER JOIN. Is there some way I can tell whether the word “OUTER” in the Informix SQL above is signifying a left, right, or full outer join?