Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> anyone way to use a wildcard in a decode?

anyone way to use a wildcard in a decode?

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 11 Jun 2003 12:55:26 -0700
Message-ID: <1efdad5b.0306111155.78871856@posting.google.com>


If I can manage this, I can condense about 10 insert statements into one and save alot of processing time.

anyway to do this with a straight decode?

ME>create table xx(y varchar2(20));

Table created.

ME>insert into xx values('ABCD');

1 row created.
ME>commit;

Commit complete.

ME>select decode(y,'%A%','XXXXX') from xx;

DECOD


1 row selected.

ME>select decode(y,'%A%','XXXXX','BLAH') from xx MASTER_TEST2_at_BOBAIRD>/ DECOD



BLAH Received on Wed Jun 11 2003 - 14:55:26 CDT

Original text of this message

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