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.

Source: stackoverflow.com

Similar codes

1 vote114 views1 answer
Scaffold mysql database
SQL
0 vote121 views1 answer
Sql dmv to capture updates
SQL
1 vote164 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote113 views2 answers
Mysql on update current_timestamp
SQL
0 vote140 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote120 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote115 views1 answer
Procedures sql insert mysql
SQL
0 vote125 views1 answer
Get last date join sql
SQL
0 vote125 views1 answer
Sqlalchemy get ids
SQL
9 votes125 views2 answers
Convert data type in sql
SQL