fastest "is number" oracle 9i

From: valigula <valigula_at_gmail.com>
Date: 12 May 2007 12:05:39 -0700
Message-ID: <1178996739.197270.197770@p77g2000hsh.googlegroups.com>

HI
What is the fastest way on returning all the valids numerics from a column.
MAT_CODIGO these are valids code

IA9903000395
VD9903300268
VD9902700081
VD9904100358
VC9804105617
VD9903300267
VC9903300088
VC9904101559
VC9804105613
VD9902700080
VD9904100212
2000001054007
VD9904100363

and there are some as:
VD990410.363

Thanks in advance ... Received on Sat May 12 2007 - 14:05:39 CDT

This message: [ Message body ]
Next message: Niall Litchfield: "Re: Parameter to influence Oracle's Idea of IO Cost?"
Previous message: Joe: "Re: Moving 10g from server to server."
Next in thread: frank.van.bortel_at_gmail.com: "Re: fastest "is number" oracle 9i"
Reply: frank.van.bortel_at_gmail.com: "Re: fastest "is number" oracle 9i"
Reply: Michael O'Shea: "Re: fastest "is number" oracle 9i"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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