Oracle clients

A short list:

• dbVisualizer
• Toad
• Oracle SQL Developer

Cannot install Java JDK: semicolon found in selected path

There's no semi colon in the install path. But you still get the error:

        semicolon found in selected path

Solution is to move the install .exe to c:\ and run it again.

Possibly with command line switches: /v"/L c:\install.log"

(Search results show that this same issue has existed for 11 years!)

Where to download oracle wallet mkstore

It looks like mkstore was the utility in 10r2 but by 11g it had been deprecated by orapki.

An article mentioning both tools.

Oracle commands for MySQL/PostgreSQL users

Oracle tips for MySQL users:

• Simple range: SELECT * FROM (SELECT * FROM foo) WHERE ROWNUM <= 100; -- equivalent of MySQL's LIMIT clause, only for start of table
• Wrong range: SELECT * FROM (SELECT rownum r, f.bar FROM schema.foo f) WHERE r > 100 AND r <= 200; -- Selects a range, but order will be inconsistent, even if you add ORDER BY to inner select
• Right range:

  SELECT * FROM (
      SELECT q.*, ROWNUM r FROM (
          SELECT * FROM schema.foo ORDER BY id
      ) q
  ) WHERE r >= 100 AND r < 200

  (source)
• SELECT last_name FROM employees WHERE last_name LIKE '%d_g\_cat%' ESCAPE '\';
• matches dog_cat, foodig_catbar, etc.
• _ = any single character
• % = any characters
• \_ = literal _ (underscore)
• ESCAPE '\'; -- set the escape character to \ (backslash)
• SELECT ...... WHERE REGEXP_LIKE (instance_name, '^Ste(v|ph)en$');
• ALTER USER foo IDENTIFIED BY "newpassword456!" REPLACE "oldpassword123!"; -- change password (REPLACE is new in 9.2)

(Oracle docs, basic elements, datatypes, conditions)
(source)

Reasons not to use stored procedures in databases

http://www.tonymarston.net/php-mysql/stored-procedures-are-evil.html