Oracle Newbie Question - How can one run selects from different tables but show output on separate rows
Is possible to merge/add the result of two or more different queries using:

UNION ALL


But count and names of columns must match on each query. 

Of course you can add null or fixed values as needed.

SELECT COL1 AS ID, COL2 AS NAME, NULL AS INFO
FROM   TABLE1
UNION ALL
SELECT F1 AS ID, F2 AS NAME, INFO
FROM.  TABLE2
UNION ALL
SELECT 0 AS ID, NAME, INFO
FROM   TABLE3