Re: alter view

Try

create or replace view...

Brian Forster wrote in message ...
>Quick question from a beginner:
>
>What is the syntax of alter view? I am trying to change an existing view
>but it doesn't like the syntax-- I did it just like create view
>
>alter view "viewname" as ...
>
>The references I've tried say it is alter view viewname compile--
>
>Bottom line to I need to drop a view and recreate it each time or is there
>an alter view statement that lets that view be updated.
>
>Thanks in advance
>
>Brian Forster
>Thomson Indiana
>Application Support
>
>
Received on Thu Sep 30 1999 - 19:06:59 CDT