How to Change a View

[marcos.santos]

I created a view based on the sale and customer tables however now I changed the client table by adding a CNPJ column that is a candidate key and would like to include change also in the view.
I would like to know how this procedure.


Thanks!

Environment information:
* Oracle version: 10g
* Operating system: XP
: -O

[dr_gori]

You have to re-create the view.

Select all

CREATE OR REPLACE VIEW nomedaview AS select bla bla bla etc

hence adds the new field in the View SQL.

[marcos.santos]

Thank you very much, my friend!