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

Home -> Community -> Usenet -> c.d.o.server -> Re: Simply question about TO_NUMBER function

Re: Simply question about TO_NUMBER function

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Thu, 03 Feb 2005 06:41:44 +0100
Message-ID: <89e301d6jdhhgqrecvt42hrpbbo3vl1eb5@4ax.com> 





On Thu, 3 Feb 2005 00:18:06 +0100, "MariMax"
<massimo.panero_at_powertiscali.it> wrote:



>Someone have another idea to resolve the problem quickly?





Try using the correct datatype for your needs: don't store numbers in
varchar2's. Especially never use function(<column) = constant as this
will prevent the use of indexes, or you must be trying to be put
together an application as inefficient as possible.



--
Sybrand Bakker, Senior Oracle DBA


Received on Wed Feb 02 2005 - 23:41:44 CST












Original text of this message













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