10g_fav_union2.sql

来自「OReilly Oracle PL SQL Programming第4版源代码」· SQL 代码 · 共 14 行

DECLARE
   our_favorites   
      strings_nt := strings_nt ();
BEGIN
   our_favorites := 
      authors_pkg.veva_authors 
	   MULTISET UNION 
	authors_pkg.steven_authors;
	  
   authors_pkg.show_authors (
      'VEVA THEN STEVEN', our_favorites);
END;
/