Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Can we have CLOBs in a UNION please
Wed, Aug 13 2014 3:49 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

As the title says

Roy Lambert
Tue, Sep 23 2014 6:59 AMPermanent Link

Adam Brett

Orixa Systems

Roy

Do you use the "UNION ALL" statement?
Or are you asking for something different from this?
Wed, Sep 24 2014 5:04 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Adam

>Do you use the "UNION ALL" statement?
>Or are you asking for something different from this?

It works but if that's in the sql spec then the sql spec just gone down in my opinion (from a low starting point)

My understanding of the difference between UNION and UNION ALL is that UNION eliminates duplicate rows and UNION ALL doesn't.

Roy
Wed, Oct 1 2014 5:19 AMPermanent Link

Adam Brett

Orixa Systems

>>It works but if that's in the sql spec then the sql spec
>>just gone down in my opinion (from a low starting point)

It does work & SQL Spec always seemed a mess to me too Smile

>>My understanding of the difference between UNION and
>>UNION ALL is that UNION eliminates duplicate rows and
>>UNION ALL doesn't.

My introduction to using UNION ALL was specifically to allow addition of BLOB / CLOB ... so it came as a total shock to me when I was told that UNION eliminates duplicates!

You are 100% right that it is a stupid mis-mash, using 1 term for 2 different processes.
Image