Install latest version of Oracle ODBC

To install latest version of Oracle ODBC: Go to http://www.oracle.com/technology/tech/oci/instantclient/ to download: Instant Client Package – Basic Instant Client Package – ODBC Unzip both of them into the same folder (e.g. c:\oracle). Add that folder name into the PATH environment variable (right click my computer, manage, system properties, advanced tab, environment variables) Create a new […]

Read More Install latest version of Oracle ODBC
June 17, 2010

Plugins for WordPress Code Display

This plugin is pretty much essential to get wordpress to display code: Syntax Highlighter and Code Prettifier Plugin for WordPress The other plugins I use are: wp-table Google XML Sitemaps Akismet

Read More Plugins for WordPress Code Display
June 8, 2010

chr(163) for £ pound character

Use chr(163) for the ‘£’ character, especially in stored SQL such as create procedure scripts, where you can’t be sure what client character settings might be used to re-create the procedure. SELECT m.description, chr(163)||TO_CHAR(m.weekly_rate, ‘999.99’) amount from my_table m; This plsql gives the full list of ASCII codes: set serveroutput on size 10240 declare i […]

Read More chr(163) for £ pound character
June 8, 2010

SQL profile drop

If you have accepted a sql profile from a tuning advisor recommandation like: execute dbms_sqltune.accept_sql_profile(task_name => ‘TASK_239607’, replace => TRUE); Then the regression commands to back it out are like: select name from dba_sql_profiles; exec dbms_sqltune.drop_sql_profile(‘MYNAME’)

Read More SQL profile drop
June 3, 2010

Change oracle password temporarily

Want to connect as a particular user but don’t know their password? You can temporarily change it and then reset it back, if you have DBA/alter any user privilege: set pages 9999 lines 132 long 9999 column col1 form a132 SELECT DBMS_METADATA.get_ddl ( ‘USER’ , ‘MYUSER’ ) AS col1 FROM DUAL ; ALTER USER myuser […]

Read More Change oracle password temporarily
June 3, 2010