Re: select where for a specific pattern

From: Anurag Varma <avoracle_at_gmail.com>
Date: 7 Jul 2006 11:53:10 -0700
Message-ID: <1152298390.674876.181930@m79g2000cwm.googlegroups.com>

LHradowy wrote:
> I have a column that I need to select on:
> Data looks like:
> 01 002 120
> 01 002 160
> 01 005 120
> 01 002 125
> 01 1 00 02 1
> 01 2 00 02 3
> 01 2 03 02 3
> 01 042 160
> 01 2 06 02 3
> 01 202 167
> etc.
>
> I need to only pull this type of format:
> ## ### ###
>
> select col1 from table1 where col1 like??
>
> Next question:
> How to update, this type of format:
> ## ### ###
>
> To this type of format:
> ## # ## ## #

What oracle version?
What have you tried so far?

Anurag Received on Fri Jul 07 2006 - 13:53:10 CDT