1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

how to find string length of size 100 kb

Discussion in 'SQL PL/SQL' started by laxman, Apr 28, 2010.

  1. laxman

    laxman Forum Expert

    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    230
    Location:
    MUMBAI
    Hi all,
    I have one table.

    Code (SQL):
    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
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    What do u mean by that ? Dont you want to allow >100KB for the column req_b.requesttext ? You could add check constraint for that purpose.
     
  3. laxman

    laxman Forum Expert

    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    230
    Location:
    MUMBAI
    Thanks sir, problem solved with check constraint.

    Regards
    Laxman