Yes, I returned the length. I assumed that you could figure out how to do
the division. :-)
select length (some_text) /80
from (select replace (replace ( 'test'
|| CHR (13)
|| 'more text'
|| CHR (9)
|| 'even more text'
|| CHR (13)
|| 'more text'
|| CHR (9),
CHR (13), RPAD (' ', 80)),
CHR (9), RPAD (' ', 5)) some_text
from DUAL);
Regards,
Mike
(where did you get Malcolm from?) lol
On Tue, Sep 23, 2008 at 6:58 AM, Vlad <[EMAIL PROTECTED]> wrote:
>
> Hi Malcolm,
>
> I believe that your function returns the length of the text.
>
> I need to know the number of lines that the text box would occupy
> given a fixed column width (I had used 80 but it makes life easier if
> you use a lower number for testing - e.g. 10)
>
> In the example you provided the text would look like this:-
>
> test
> more text even more
> text
> more text
>
> This text therefore takes up 3 lines.
>
> Thanks
>
> Andy
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
