Re: Quotes not mandatory for String condition ?

From: Zboub <zboub_at_softhome.net>
Date: 12 Jul 2005 08:33:28 -0700
Message-ID: <1121182408.815500.43880@g44g2000cwa.googlegroups.com>

Thank you for the Reply, Mark, Sybrand and Paul :)

ok, now I know what is an implicit type conversion, I'm a newbie on Oracle ;)
"Oracle can't defend itself against stupid designers and stupid developers." --> lol ! I will transfert your quote to ours developers ;)

In fact the columns must be designed as VARCHAR2 because it may contains alphanumeric data. It's a particular case of few of ours customers to have putted only numbers into this column.

What is wrong in our program is not the Varchar2 state of the column, but the missing quotes when conditions are used on this column.

3) Thank you very much for the URL, I have read the "function based indexes" chapter.
My next actions are both : talk with our R&D departement about the missing quotes, and talk with one of our real DBA (not me!) for a temporary solution with a temporary function bases index.

Thank you very much guys ! :)

Patrick. Received on Tue Jul 12 2005 - 10:33:28 CDT