michaeljc70_at_hotmail.com wrote:
> 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.
www.psoug.org
click on Morgan's Library
click on Pipelined Table Function
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Aug 08 2005 - 23:55:15 CDT
