Monthly Archives: June 2010

Install latest version of Oracle ODBC

Posted on 17 June 2010 by Andrew Fraser

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 … Continue reading →

Posted in Installs, Windows | Leave a comment

O’Reilly’s Steve Feuerstein Oracle PL/SQL Programming

Posted on 16 June 2010 by Andrew Fraser

O’Reilly’s Steve Feuerstein Oracle PL/SQL Programming, 2nd Edition online at http://soft.buaa.edu.cn/oracle/bookshelf/Oreilly/prog2/

Posted in Book review, PL/SQL | Leave a comment

Plugins for WordPress Code Display

Posted on 8 June 2010 by Andrew Fraser

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

Posted in Wordpress | Leave a comment

chr(163) for £ pound character

Posted on 8 June 2010 by Andrew Fraser

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 … Continue reading →

Posted in Character sets | Leave a comment

chr(13) chr(10) carriage return line feed CR LF

Posted on 8 June 2010 by Andrew Fraser

chr(13) and chr(10) are the carriage return line feed CR LF characters, so to strip them out: select replace(replace(m.long_notes,chr(10),’ ‘),chr(13),’ ‘) from mytable m;

Posted in Character sets | Leave a comment

sqltrpt readable formatting

Posted on 3 June 2010 by Andrew Fraser

Output of sqltrpt is more readable with these settings: set pages 9999 lines 192 col plan_plus_exp form a132 @?/rdbms/admin/sqltrpt

Posted in Performance tuning | Leave a comment

Setting bind variables in sql*plus

Posted on 3 June 2010 by Andrew Fraser

variable b1 varchar2(6) ; exec :b1 := ’2009′ Used mainly for sql tuning rather than in real code.

Posted in Performance tuning | Leave a comment

SQL profile drop

Posted on 3 June 2010 by Andrew Fraser

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’)

Posted in Performance tuning | Leave a comment

Change oracle password temporarily

Posted on 3 June 2010 by Andrew Fraser

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: SQL> select password from dba_users where username = ‘MYUSER’; PASSWORD —————————— … Continue reading →

Posted in Uncategorized | Leave a comment