Hi All,
I have the following function that i am trying to convert to Oracle
but need a few pointers. Is there an oracle equivalent of the XML
data type which you can use in the same way:-
ALTER FUNCTION dbo.CntLines(@Str VARCHAR(8000),@LineBreakSting
varchar(2),@ColWidth decimal)
RETURNS INT
BEGIN
declare @NbrLines INT,@x xml
set @NbrLines = 0
SET @x = '<i>' + REPLACE( replace(@Str, char(9), ' '),
@LineBreakSting, '</i><i>') + '</i>'
SELECT @NbrLines =
sum(case when len(x.i.value('.', 'VARCHAR(8000)')) > @ColWidth then
ceiling(len(x.i.value('.', 'VARCHAR(8000)'))/@ColWidth) else 1 end)
FROM @x.nodes('//i') x(i)
where x.i.value('.', 'VARCHAR(8000)') > ''
RETURN @NbrLines
END
TIA
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
