Ok, but you mentioned nothing in your requirement about XML. Do you need to use XML or did you just put it in your original example because the TSQL author just found XML to be a convenient way to solve the problem?
On Mon, Sep 22, 2008 at 3:42 PM, Vlad <[EMAIL PROTECTED]> wrote: > > Thanks Michael ;-) > > To be honest I don't actually know 'how' the above function works, I > do know what it does though - it calculates the number of lines that a > text string will take up given a fixed column width. > > I know that this should normally be done by the presentation layer but > there are other reasons why doing it at the DB layer is actually > sensible. > > The things which make this more difficult than dividing the number of > characters by the line width are the following things:- > > - 10 carriage returns will actually take up 10 lines irrespective of > the column width, however they would only take up 10 characters > - Tab spaces take up 4-5 characters (simple solution is to replace all > characters in the string with 4-5 spaces) > > Any pointers would be gratefully received. > > Thanks > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
