Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> anyone way to use a wildcard in a decode?
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