aspose file tools*
The moose likes JDBC and the fly likes UNION for Columns of CLOB data type does not work Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "UNION for Columns of CLOB data type does not work" Watch "UNION for Columns of CLOB data type does not work" New topic
Author

UNION for Columns of CLOB data type does not work

Monoranjan Gorai
Greenhorn

Joined: Jul 25, 2005
Posts: 19
Hi,
I have two tables Encounter & Encounter_History. They have same columns. One column is of type CLOB. My requirement is to retrieve all the distinct records from both the tables with order by a date column. But problem is, UNION does not work in case of CLOB data type.

I know it will work if I use UNION ALL, but it returns duplicate records.

Please give me suggestion, how to solve this problem.

For example: The following query does not work since column1 is a CLOB data type

select column1 from table1
union
select column1 from table2

Thanks
 
Don't get me started about those stupid light bulbs.
 
subject: UNION for Columns of CLOB data type does not work