Disapprove with me!

Okey, you know Oracle. A very good database, a very old database, a very solid rock. Not famous for its error messages. I have already stumbled upon a misleading error on the old rock.

I stumbled upon a very brain-f**k error on Oracle 10g on these days.

Context: the following query [sql]SELECT * FROM (
SELECT TO_NUMBER(CUSTOMER_ID) AS SNDG FROM BAD_CODES_TABLE WHERE
AND I_LIKE=UPPER(‘STATIC_CONDITION’) AND CUSTOMER_ID NOT LIKE ‘%P%’ ) S WHERE TO_NUMBER(S.SNDG) >2000[/sql] could trigger a Invalid number if CUSTOMER_ID column contains invalid numbers.

Why?

Well…if you ask to “explain plan”, you will get something like

• a table full scan
  • Filter Predicates AND
    • I_LIKE=UPPER('STATIC_CONDITION')
    • TO_NUMBER(S.SNDG) >2000
    • CUSTOMER_ID NOT LIKE '%P%'

Sometimes, a client-based refresh of the session is the only viable option.

I have used Google in the past 8 years (I know, I am a bit old). Then I was annoyed because of a bad behavior of Google with my AdSense account (shutdown without being able to talk back to someone for explanation).

About Diaspora, we read from Ars Technica (underline is our):

iPhone is the brand-new Apple product which has changed the way Apple thinks. Because of iPhone, Apple strip the word "Computers" from its brand name. And because of iPods and iPhone products, Lepoard developmenet slip a bit, blurring the focus on pure technology.
To be true, I do not beat on  the iPhone success, but the product success is at least  bright this year. And the iPod touch has also added value to the iPods product catalog. But I am an IT-man, damn you boy! So I want to buy it to play with it, to program with it!

Hi all, dear readers (and spammers too... you delight me with your poor tatics)!
Because my job is getting very very boring, and my private life is full of fantastic nights, I have decided to write a bunch of new articles, and stack them on objectsroot.com.

My first webcam video....
See and have fun: http://www.youtube.com/watch?v=53CIgqpD0S8