Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

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.

If it is multiple choice, the questions shouldn't be ambiguous (where either is a correct answer). If it is a "write a query to produce this data", you should follow the best practices for that database to the best of your ability. – user40980 Jan 4 '13 at 22:23
up vote 1 down vote accepted

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.

share|improve this answer
bad advice: the (+) syntax (while great) is considered obsolete by Oracle. Stick with the standard, everyone should be familiar with it by now. – gbjbaanb Jan 5 '13 at 1:47

Not the answer you're looking for? Browse other questions tagged or ask your own question.