Re: Querying a number column.

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 20 Jan 2003 08:14:33 -0800
Message-ID: <3E2C2068.8AA099C8@exesolutions.com>

elziko wrote:

> I have noticed that you can query using Number column in SQL like this:
>
> SELECT * FROM mytable WHERE numbercol = '100'
>
> ...where numbercol is a Number Column! The bit I'm questioning is the quotes
> around the 100. Normally for a number column you would not use these I know
> but is there any performance decrease if you do?
>
> Cheers,
>
> elziko

This is asking Oracle to perform an implicit conversion and should never be done as Oracle makes no guarantee that it will work every time nor that it will work at all in the future.

Daniel Morgan Received on Mon Jan 20 2003 - 10:14:33 CST