-
Notifications
You must be signed in to change notification settings - Fork 14
Expand file tree
/
Copy path10g_union.sql
More file actions
40 lines (26 loc) · 1.27 KB
/
Copy path10g_union.sql
File metadata and controls
40 lines (26 loc) · 1.27 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
DECLARE
our_authors strings_nt := strings_nt();
BEGIN
our_authors := authors_pkg.steven_authors
MULTISET UNION authors_pkg.veva_authors;
authors_pkg.show_authors ('MINE then VEVA', our_authors);
our_authors := authors_pkg.veva_authors
MULTISET UNION authors_pkg.steven_authors;
authors_pkg.show_authors ('VEVA then MINE', our_authors);
our_authors := authors_pkg.steven_authors
MULTISET UNION DISTINCT authors_pkg.veva_authors;
authors_pkg.show_authors ('MINE then VEVA with DISTINCT', our_authors);
our_authors := authors_pkg.steven_authors
MULTISET INTERSECT authors_pkg.veva_authors;
authors_pkg.show_authors ('IN COMMON', our_authors);
our_authors := authors_pkg.veva_authors
MULTISET EXCEPT authors_pkg.steven_authors;
authors_pkg.show_authors (q'[ONLY VEVA'S]', our_authors);
END;
/
/*======================================================================
| Supplement to the fifth edition of Oracle PL/SQL Programming by Steven
| Feuerstein with Bill Pribyl, Copyright (c) 1997-2009 O'Reilly Media, Inc.
| To submit corrections or find more code samples visit
| http://oreilly.com/catalog/9780596514464/
*/