Joining sql views in oracle sql

How can I join views using sql? I'm 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'm doing this to check if the fragmentation is correct, if you get what i mean. Thanks :))

Answers


These will be distinct result sets as the libname is different so use UNION ALL rather than UNION

SELECT * FROM florence_staff
UNION ALL
SELECT * FROM alexandria_staff

Need Your Help

Linux buffer cache for DVD/FUSE?

linux caching filesystems linux-kernel vfs

I want to know whether the buffer cache in Linux kernel is present for file systems like UDF for DVD and FUSE?

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.