Skip to content

Daily Archives Friday, August 2008

Off Topic: The Katrina Myth

LewisC’s An Expert’s Guide To Oracle Technology
On this, the third anniversary of Hurricane Katrina, there is a hurricane (Gustav) setting its sights on New Orleans (and another, Hanna, in the Atlantic). It’s looking like it might be a busy storm ye…

Posted 29 August 2008 † An Expert's Guide to Oracle Technology § Uncategorized ‡ Comments Off °

APEX 3.1.2 patch applied successfully

If you didn’t hear about it yet, you must only read this blog and no others ;-)Yesterday a new Patch came out for Oracle Application Express. If you look at the number of fixes I think it’s worthwhile to apply the patch. Depending the version of APEX y…

Posted 29 August 2008 † Dimitri Gielis § Uncategorized ‡ Comments Off °

cx_Oracle and DBMS_APPLICATION_INFO

Here’s another post from the old blog, harvested from archive.org The other day I was playing with some Python and cx_Oracle, a Python module for connecting to Oracle databases. While cx_Oracle seems to work great, I found the documentation light…

Posted 29 August 2008 † sergio.leunissen § Uncategorized ‡ Comments Off °

OTN Forums - Change the look and feel yourself

The recent OTN Forums update has been heavily blogged/Twittered/posted about already, so I’m not even going to touch that one.
However, one thing that a few people have focused on (pardon the pun) is that the update has changed the way that viewed threads are displayed in a very light grey colour, making them a bit [...]

Posted 29 August 2008 † John Scott § Uncategorized ‡ Comments Off °

Taking a Staycation

I’m off on a staycation for a while. Since I’ll be at home, there’s a good chance it may turn into a workcation.
I know it sounds weird, but the temptation to work is always there when you work from home. Sounds even crazier out loud. I’m sure the wife will box my ears if she [...]

Posted 29 August 2008 † Jake § Uncategorized ‡ Comments Off °

what is faster, select count(*) or select count(pk) ?

Oh no, not another post about COUNT(*) and COUNT(1)
Well, it is not exactly the case. I just had the issue this morning that count(*) was too slow.

SQL> create table t as select rownum id,
  2    lpad('a',4000,'a') a,
  3    lpad('b',4000,'b') b,
  4    lpad('c',4000,'c') c,
  5    lpad('d',4000,'d') d
  6  from dual connect by level<10000;

Table created.

SQL> create index i on t(id);

Index created.

SQL> alter table t [...]

Posted 29 August 2008 † Laurent Schneider § Uncategorized ‡ Comments Off °

Application Express 3.1.2 Upgrade - Session Zero and Redirects

I was glancing through the list of fixed bugs in the Apex 3.1.2 release and noticed that one of my long time ‘annoyances’ has been fixed.
Many people have had problems getting their Apex applications indexed by Google and other search engines. One of the reasons for this was that Google (and other search engines) [...]

Posted 29 August 2008 † John Scott § Uncategorized ‡ Comments Off °