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: SQL tuning with LIKE expression

Re: SQL tuning with LIKE expression

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 22 Sep 2003 22:33:23 +0200
Message-ID: <83numvo78k3kn3tta6tgci6ljjs3pahv8n@4ax.com>


On 22 Sep 2003 09:43:22 -0700, letsconnect_at_hotmail.com (Junaid) wrote:

> For utility purposes, I have to use the like expression in the where
>clause.

No, you don't. There is no reason to use LIKE on a number column.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Sep 22 2003 - 15:33:23 CDT

Original text of this message

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