CODE EXAMPLE FOR SQL

oracle sql create view

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