Sql - Union

Data System Architecture

About

Relational Algebra - Union operator in SQL.

How to

generate dynamically a SQL Union statement

Example in oracle:

select 
  statement || decode(rownum, max(rownum) over (partition by 1),' order by numberOfRows, table_name;',' union all')
from
(
  select 'select '''||table_name||''' table_name, count(1) numberOfRows from ' || table_name as statement
  from user_tables
  order by table_name
);





Discover More
Data System Architecture
SQL - Null

NULL value in SQL represents missing data in SQL. NULL has its own data domain and implements therefore its own behavior. The most important one being that: An equality comparison of two NULL values...
Venn Diagram
Set Theory - Union

Set Theory - Union



Share this page:
Follow us:
Task Runner