Re: Dumb Character Column

From: Robert Klemme <>
Date: Wed, 27 Jan 2010 20:33:37 +0100
Message-ID: <>

On 27.01.2010 17:31, The Magnet wrote:

> We are on Oracle 10g. My solution was that of above. Do a function
> that returns a 1 or 0 and query based on that:

If you only need numbers and there is a significant amount of non numbers you could also return NULL for non numbers in order to keep the index small.



remember.guy do |as, often| as.you_can - without end
Received on Wed Jan 27 2010 - 13:33:37 CST

Original text of this message