{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 兄弟一词,经得起流年. 的问题《Select distinct on blob》','https://www.manongdao.com/q-1280966.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
Is there a way to verify if the value in blob in more rows is identical in the Oracle database? The blob is the same column.
I have the size of the blob stored in another column but I need to know if the value is equal too.
The value stored is a serialized object.
I would recommend adding another column which contains the hash of the blob value. When you store the blob you also calculate the hash value, using
SHA256for example, and store that. When you later want distinct values you just use this new column.