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!

The check sum for a particular blob column of a record in the db table

Discussion in 'General' started by rajinquest, Oct 8, 2013.

  1. rajinquest

    rajinquest Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    How can we get the check sum for a particular blob column of a record in the db table.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
  3. rajinquest

    rajinquest Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Thank you for the response. Also wanted to know about this approach. what if I copy that particular blob column of a record in the db table to a temporary table (using the create table reports as select blob column from blobtable where some id = 1). This way the temporary table will be having only one column then we can get the rowid for that row and call the OWA_OPT_LOCK.CHECKSUM passing the rowid and other parameters. Do you think this approach is good.
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    As long as the 'temporary' table isn't a global temporary table that should work.