Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!m79g2000cwm.googlegroups.com!not-for-mail
From: "Anurag Varma" <avoracle@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: select where for a specific pattern
Date: 7 Jul 2006 11:53:10 -0700
Organization: http://groups.google.com
Lines: 33
Message-ID: <1152298390.674876.181930@m79g2000cwm.googlegroups.com>
References: <1152296127.224677.293310@m79g2000cwm.googlegroups.com>
NNTP-Posting-Host: 13.13.137.1
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1152298395 24236 127.0.0.1 (7 Jul 2006 18:53:15 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 7 Jul 2006 18:53:15 +0000 (UTC)
In-Reply-To: <1152296127.224677.293310@m79g2000cwm.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.4) Gecko/20060508 Firefox/1.5.0.4,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: m79g2000cwm.googlegroups.com; posting-host=13.13.137.1;
   posting-account=Bjij0w0AAACWMZ9jVkCMjBKLT0Yf1PAH
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:270610


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