Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Quotes not mandatory for String condition ?

Re: Quotes not mandatory for String condition ?

From: <sybrandb_at_yahoo.com>
Date: 12 Jul 2005 06:11:12 -0700
Message-ID: <1121173872.837054.212530@g49g2000cwa.googlegroups.com>


1 implicit type conversion. Would you like to receive an error instead? The implicit type conversion always is
<conversion function>(database column) = <literal or bind variable of the incorrect type>
2 Oracle can't defend itself against stupid designers and stupid developers.
The column should have not been designed as VARCHAR2 in the first place!!!
3 Look up function based indexes on http://tahiti.oracle.com (or, undoubtedly, go to http://www.psoug.org and click on Morgan's library, and click on 'Function based indexes')

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Tue Jul 12 2005 - 08:11:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US