Technology Editor:SQL :Not Ordered Join

  •  The parameters of non-sequenced joins allow outer join clauses to be generated in the WHERE clause.



  •  Outer Keyword  Keyword or sign imposed by the syntax as a reminder that an element is considered external. For example, for Oracle the Outer Keyword is: (+).
  •   Outer location  Shows if the OUTER Keyword is located outside (OUTER side) or inside (INNER side) the join syntax.
  •   Clause Location  Shows if the OUTER Keyword should be placed before or after the name of the object contributing to the join.


No comments:

Post a Comment