Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Lv 2335 points

jac2703

Favorite Answers27%
Answers45

  • How to charge and discharge a capacitor?

    I am trying to make a simple game where you get a shock if you do something wrong.

    I have a capacitor which I have taken out of an old computer monitor. Is there a way I can charge the capacitor and then discharge it to produce a small shock?

    5 AnswersEngineering1 decade ago

  • Does it matter in Oracle 10 SQL if restrictions are in the JOIN part or the WHERE?

    Hi All,

    This is my first question post so be gentle.

    My question relates to Oracle SQL and ANSI joins

    If i write a query as follows:

    SELECT *

    FROM table1 a

    JOIN table2 b ON a.id = b.id AND a.field1 > 4

    AND a.field2 = 'MY VALUE'

    Would there be any performance difference if i put the non-join restrictions in the WHERE? Example:

    SELECT *

    FROM table1 a

    JOIN table2 b ON a.id = b.id

    WHERE a.field1 > 4

    AND a.field2 = 'MY VALUE'

    Further, if i was to write a larger script and use 6+ joins, would there be a performance difference if i put the non-join restrictions in the JOIN vs. WHERE (basically the same two examples as above, only with more joins)?

    Thanks for your time,

    J

    1 AnswerProgramming & Design1 decade ago