How to compare clob columns of single table in oracle? [closed]

by

This code should work:

select * 
    from table 
   where dbms_lob.compare(aClobColumn, bClobColumn) = 0

PS: I haven’t tried running it as I am not having access to an Oracle instance at the moment.

Reference: https://docs.oracle.com/database/121/ARPLS/d_lob.htm#ARPLS600

More Related Contents:

  1. How to query a CLOB column in Oracle
  2. Exporting a CLOB to a text file using Oracle SQL Developer
  3. The most efficient way to UPPER CASE two columns in a single query [closed]
  4. Current date in Oracle Db
  5. query about check constraint [closed]
  6. Split comma separated values to columns in Oracle
  7. How to load a large number of strings to match with oracle database?
  8. Oracle SELECT TOP 10 records [duplicate]
  9. Select a random sample of results from a query result
  10. SQL error “ORA-01722: invalid number”
  11. Disable all table constraints in Oracle
  12. Get month name from date in Oracle
  13. ORA – 00933 confusion with inner join and “as”
  14. SQL Error: ORA-00942 table or view does not exist
  15. How to count the number of occurrences of a character in an Oracle varchar value?
  16. Comparing with date in Oracle sql
  17. SQL selecting rows by most recent date with two unique columns
  18. How to extract group from regular expression in Oracle?
  19. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  20. How to extract week number in sql
  21. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  22. How to handle optional parameters in SQL query?
  23. Return number from Oracle Select statement after parsing date
  24. How do you interpret a query’s explain plan?
  25. Oracle DB: How can I write query ignoring case?
  26. ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)
  27. How to call Oracle MD5 hash function?
  28. Oracle Convert TIMESTAMP with Timezone to DATE
  29. SQL Server equivalent of WM_CONCAT function [duplicate]
  30. Oracle: ‘= ANY()’ vs. ‘IN ()’

Leave a Comment