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

3 votes153 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
1 vote204 views1 answer
Show databases mysql docker
SQL
16 votes150 views2 answers
Sql exists
SQL
0 vote145 views6 answers
Unique key in sql
SQL
-1 vote204 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote152 views1 answer
Mysql get longest string in column
SQL
10 votes165 views2 answers
Forgot my mysql password mac
SQL
15 votes141 views7 answers
MYSQL
SQL
1 vote146 views1 answer
Change old domain to new domain name wordpress
SQL
1 vote169 views1 answer
Apex select list ORA-20999
SQL