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

0 vote248 views1 answer
Mysql timeout 30 seconds
SQL
0 vote371 views1 answer
How to rename a database in tsql
SQL
8 votes285 views3 answers
Postgres connection string
SQL
0 vote279 views1 answer
SqlFunction does not exist
SQL
0 vote293 views1 answer
Get who is hired in month in sql
SQL
5 votes311 views4 answers
Upload database mysql command line
SQL
1 vote272 views2 answers
How to check username in mysql command line
SQL
3 votes284 views1 answer
Sql replace character in string in all records
SQL
25 votes302 views6 answers
Import mysql database command line
SQL
1 vote296 views1 answer
ORACLE RIGHT TWO DIGITS
SQL