UNION-UNION ALL- INTERSECT - MINUS ( EPU/ETEC/ISED/Stage 4/SDB)
Enter user-name: system
Enter password:
Connected.
SQL_ create table a (id number, name varchar(10));
Table created.
SQL_ create table b (id number, name varchar(10));
Table created.
SQL_ insert into a values (1 , 'ali);
ERROR:
ORA-01756: quoted string not properly terminated
SQL_ insert into a values (1 , 'ali');
1 row created.
SQL_ insert into a values (2 , 'Kamal');
1 row created.
SQL_ insert into a values (3 , 'Dana');
1 row created.
SQL_ insert into b values (1 , 'Dana');
1 row created.
SQL_ insert into b values (2 , 'soran');
1 row created.
SQL_ insert into b values ( 3 , 'helen');
1 row created.
SQL_ insert into b values ( 4 , 'shadi');
1 row created.
SQL_ select * from a;
ID NAME
---------- ----------
1 ali
2 Kamal
3 Dana
SQL_ select * from b;
ID NAME
---------- ----------
1 Dana
2 soran
3 helen
4 shadi
SQL_ select * from a union select * from b;
ID NAME
---------- ----------
1 Dana
1 ali
2 Kamal
2 soran
3 Dana
3 helen
4 shadi
7 rows selected.
SQL_ select name from a union select name from b;
NAME
----------
Dana
Kamal
ali
helen
shadi
soran
6 rows selected.
SQL_ select name from a union all select name from b;
NAME
----------
ali
Kamal
Dana
Dana
soran
helen
shadi
7 rows selected.
SQL_ select name from a intersect select name from b;
NAME
----------
Dana
SQL_ select name from a minus select name from b;
NAME
----------
Kamal
ali
SQL_ select * from a;
ID NAME
---------- ----------
1 ali
2 Kamal
3 Dana
SQL_ select * from b;
ID NAME
---------- ----------
1 Dana
2 soran
3 helen
4 shadi
SQL_ select name from a minus select name from b;
NAME
----------
Kamal
ali
SQL_ select name from b minus select name from a;
NAME
----------
helen
shadi
soran
SQL_ select name from b minus select name from b;
no rows selected