Home » SQL & PL/SQL » SQL & PL/SQL » How to perform a checksum to a table? (Oracle SQL 11)
How to perform a checksum to a table? [message #634272] Fri, 06 March 2015 17:46 Go to next message
Adam Brave
Messages: 12
Registered: March 2015
Location: Lisboa
Junior Member
Hi,

I want to get a checksum of a table and in order to do it I was thinking in using the OWA_OPT_LOCK.CHECKSUM function. However this function per se just allow me to get a checksum of a row. How can I use it in a loop to perform a checksum to the entire table? I mean, what keywords can I use to advance to the nex row? Can you give me examples?

Thanks in advance!

Report message to a moderator

Re: How to perform a checksum to a table? [message #634285 is a reply to message #634272] Sat, 07 March 2015 00:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

http://www.orafaq.com/forum/mv/msg/196661/634275/#msg_634275

Report message to a moderator

Re: How to perform a checksum to a table? [message #634292 is a reply to message #634272] Sat, 07 March 2015 01:58 Go to previous messageGo to next message
John Watson
Messages: 9003
Registered: January 2010
Location: Global Village
Senior Member
CAn you explain why you need this? THere may be anoter way. For example, if you want to know if two tables have identical contents, you can use DBMS_COMPARISON.

Report message to a moderator

Re: How to perform a checksum to a table? [message #634334 is a reply to message #634272] Sat, 07 March 2015 16:04 Go to previous message
EdStevens
Messages: 1377
Registered: September 2013
Senior Member
Why does this sound suspiciously like this: https://community.oracle.com/message/12934414#12934414

Report message to a moderator

Previous Topic: Datapump error inside SQL dev
Next Topic: SQLPLUS PLS-00103 Encountered 'INSERT'
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Aug 25 21:17:16 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.