Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Union and blank spaces or fillers??

583143Apr 30 2008 — edited Apr 30 2008
Quick question folks;

I am writting an SQL script with a union and the second half doesn't use the same fields as the first one.

What is the correct code to allow for fillers to be used.

I am trying this:

'',''

and it works on it's own sql statement, but when put in with the UNION it comes back with the query block has incorrect number of result columns.

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2008
Added on Apr 30 2008
5 comments
3,244 views