SQL

Creating a view SQL

CREATE VIEW view_name AS
SELECT column1, column2.....
FROM table_name
WHERE [condition];

oracle sql create view

CREATE OR REPLACE VIEW view_name AS
SELECT colA, colB 
FROM my_table
WHERE colC = 'OK';

sql create view

CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;

Creating a View in SQL

CREATE VIEW us_customers AS
SELECT customer_id, first_name
FROM Customers
WHERE Country = 'USA';