What if you have two CLOB columns to compare? A construct like
where col1 != col2
will not work.
This is how you will need to compare:
select AUDIT_PAYLOAD_TEXT_DEC, AUDIT_PAYLOAD_TEXT
where dbms_lob.compare(AUDIT_PAYLOAD_TEXT_DEC, AUDIT_PAYLOAD_TEXT) != 0
The return value is non-zero if the comparison fails.
Confessions of an Oracle Database Junkie - Arup Nanda The opinions expressed here are mine and mine alone. They may not necessarily reflect that of my employers and customers - both past or present. The comments left by the reviewers are theirs alone and may not reflect my opinion whether implied or not. None of the advice is warranted to be free of errors and ommision. Please use at your own risk and after thorough testing in your environment.
Wednesday, January 16, 2008
Subscribe to: Post Comments (Atom)
so, what about the service of repair pdf document, provided by other solutions?
Post a Comment