Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Quotes not mandatory for String condition ?
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 DBAReceived on Tue Jul 12 2005 - 08:11:12 CDT
![]() |
![]() |