Simulate UNION with BLOBs
November 21, 2016 —Category: Software
TL;DR : If you have BLOB s, you need to use UNION ALL . If you use UNION ALL , you need to partition off a criterion and select the first row. The other day I had to figure out how UNION works in Oracle, because we're retrofitting an application with extra features. Assuming I have 2 tables…