How to change the definition of a view in a simple way..?
drop the view and create a new one
use CREATE OR REPLACE syntax
use ALTER VIEW syntax
use UPDATE sytax