Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mail
From: michaeljc70@hotmail.com
Newsgroups: comp.databases.oracle.server
Subject: Tricky SQL even possible?
Date: 8 Aug 2005 15:04:52 -0700
Organization: http://groups.google.com
Lines: 8
Message-ID: <1123538692.759012.272710@f14g2000cwb.googlegroups.com>
NNTP-Posting-Host: 162.136.193.1
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1123538698 6233 127.0.0.1 (8 Aug 2005 22:04:58 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 8 Aug 2005 22:04:58 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: f14g2000cwb.googlegroups.com; posting-host=162.136.193.1;
   posting-account=pzlsYwwAAABszbC6Eu4fdl6PGUHTbyUA
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249136

Basically, I've simplified down what I need from a much larger problem.
I don't even know if this is possible.  What I need is to be able to
create a select that will look at a VARCHAR2 field (call it text_field)
and generate a row for every 5 characters in that column.  In other
words, if text_field has 50 characters, I would expect to get back 10
rows which would be the numbers 1 to 10.  If it has 100 characters, I
would get back the numbers 1 to 20.