Attaching sql views in oracle sql

Question

How can I join views using sql? Am I using Oracle at the moment?

Sql view 1

CREATE VIEW florence_staff AS
SELECT *
FROM staff
WHERE libname ='florence'

Sql view 2

CREATE VIEW alexandria_staff AS
SELECT *
FROM staff
WHERE libname ='alexandria'

I do this to verify that fragmentation is correct, if you understand what I mean. Thank:))

Answer 1

These will be different result sets as libnamedifferent, so use UNION ALL, notUNION

SELECT * FROM florence_staff
UNION ALL
SELECT * FROM alexandria_staff