I am interviewing for a PL/SQL position with a large corporation. I will have to write a multiple choice exam. I am wondering whether the exam will likely use old-style joins (joining happens in the 'WHERE' clause) or ANSI ones. My apologies if this is not the correct forum for this question.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
closed as off topic by GlenH7, World Engineer♦, Glenn Nelson, GrandmasterB, Walter Jan 5 '13 at 0:17
Questions on Programmers Stack Exchange are expected to relate to software development within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.
Show them you know both styles.
I can tell you by experience that PL/SQL programmers prefer the Oracle-style joins.
I have maintained PL/SQL solution and hardly ever seen an ANSI-join.
Left and right joins and more terse because of the (+) especial Oracle keyword.
Been said that, ANSI-joins are more universal and make it easier to migrate between different RDBMS.
It's probable that your interviewer, if he/she is an Oracle lifelong programmer, is unfamiliar with the ANSI-style.
I tend to think that if you are looking for an PL/SQL position, do things the Oracle way. That's what they would expect.