Creating a view SQL
CREATE VIEW view_name AS SELECT column1, column2..... FROM table_name WHERE [condition];
Source: www.tutorialspoint.com
create view in oracle sql
create or replace view active_toys as select * from toys where is_deleted = 'N'; select * from active_toys;
Source: livesql.oracle.com