ODI Online Training for details Call 09959531832 Mail Id:obieetraining03@gmail.com
Technology Editor:SQL :Not Ordered Join
The parameters of non-sequenced
joins allow outer join clauses to be generated in the WHERE clause.
Outer KeywordKeyword or sign imposed by the
syntax as a reminder that an element is considered external. For example, for
Oracle the Outer Keyword is: (+).
Outer locationShows if the OUTER Keyword is
located outside (OUTER side) or inside (INNER side) the join syntax.
Clause LocationShows if the OUTER Keyword
should be placed before or after the name of the object contributing to the
join.
No comments:
Post a Comment