Yes Gail...I have studied...But i don't remember the functionality...
I have reviewed the above mentioed URL, Since there are lot of formula's are there,it is confusing...
If you or anybody gave the short notes about it, I will review it once again with some understanding....instead of looking it blindly...
Apart from that, I have some more questions....
1) What is mean by pseudo cursor?
"pre-allocate and Stuff" trick popular with mutable strings
2) what this trick will do?
3) What RHS (right-hand side) function denotes exactly?
I believe the way it operates is from right side....ex: substring()
right?
4) What LHS (Left-hand side) function denotes exactly?
I believe the way it operates is from left side....ex: right()
right?
OK, since I couldn't get a copy of Moby Dick, I made my own test data. Here is your test rig Phil, with my test data and my technique, followed by your original approach. Needless to say, my method is nearly linear, but the simple approach grows geometrically:
5) what are all the method available apart from linear? What is mean by linear method?
how to know whether my code use linear method?
aaah....lot of doubts.....
karthik