请问oracle 有取交集的函数吗？

请问oracle 有取交集的函数吗？
---------------------------------------------------------------

SELECT part
FROM orders_list1;

PART
----------
SPARKPLUG
FUEL PUMP
FUEL PUMP
TAILPIPE

SELECT part
FROM orders_list2;

PART
----------
CRANKSHAFT
TAILPIPE
TAILPIPE

SELECT part
FROM orders_list1
INTERSECT
SELECT part
FROM orders_list2;

PART
----------
TAILPIPE