oracle sql alter view add column code example

Example: oracle sql alter view add column

-- Views cannot be altered, they have to be recreated

-- If you want to add columns then just run the CREATE OR REPLACE VIEW 
-- statement again with a different select.