REF:Knowledge Xpert for Oracle Administration > SQL Reference > PL/SQL Language Elements > Language Elements > Collections > Collection - Nested Table Functions Set OperatorsThe set operators UNION, UNION ALL, MINUS and INTERSECT combine the results of two queries. The two queries must have the same number of columns and the columns must be of the same data type family. Like join operations, set operations combine information from multiple tables. With a join operation, you combine these tables ...
Link URL:
http://moonsoft.itpub.net/post/15182/510956
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/226700/viewspace-683117/
,如需转载,请注明出处,否则将追究法律责任。