how to find string length of size 100kb
727350Apr 28 2010 — edited Apr 28 2010Hi all,
I have one table.
sql>select * from req_b;
reqid requesttext
1 aaaaaa
2 bbbbbb
3 ccccccc
with reference to this table i need to write one logic inside plsq block where i need to handle those reqid whose requesttext length should be less than 100kb or i can say like this i need to ignore those reqid whose length is greater than 100kb
i know about length,lengthb and vsize function but not sure whether it will solve the purpose or not.
Kindly provide me some information to implement this.
Thanks n regards
Laxman