Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table Join Help Needed...
<heizer1_at_llnl.gov> wrote in message
news:1140073503.784514.64910_at_g14g2000cwa.googlegroups.com...
: Well, I just hit a snag, since that was only a sample of the subnets, I
: hit a problem with substr command some of the subnets have 10,11,12
: variations of length.
:
: So, I think this might be a better idea. I can create a view and add a
: sudo subnet column via a pattern replace. The only thing I dont know is
: can I trim the last chars of the end to make it look like a subnet?
:
: Example ...
: 127_215_3_124 = 127_215_3_
:
: Thanks,
: - Charles
:
you can use a combination of INSTR (to find the 3rd '_', or last from the end) and SUBSTR to do this, or regular expressions if your version of oracle supports them
(make sure you spend a little time getting familiar with the functions listed in oracles SQL Reference manual)
++ mcs Received on Thu Feb 16 2006 - 04:49:39 CST