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: LIKE OPERATOR

Re: LIKE OPERATOR

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Fri, 02 Jul 2004 20:14:13 +0200
Message-ID: <oe9be09c4r17jj3l1tqf92884urfj1s38g@4ax.com>


On Fri, 2 Jul 2004 17:14:33 +0500, "Oracle Newbie" <f93c0532_at_yahoo.com> wrote:

>In SQL Server I could write a condition e.g. Name Like '[ABC]%' to bring
>all names beginning with A or B or C. I see that this does not work with
>Oracle. So whats the equivalent?
>
>thx
>

The equivalent is to upgrade to 10g, where you have full regular expressions in SQL and PL/SQL

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Jul 02 2004 - 13:14:13 CDT

Original text of this message

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