create or replace view .....


you can get the text from user_views or dba_views, or from your source control system