Re: Creating Views

Gita, no , you do not have to commit once the view is created. In creating a view you simple SELECT data you want, no inserts, no , deletions, no updates, no transactions, hence nothing to commit.

Good Luck, Robert

geetha_sanjeeviah_at_p-com.com wrote:

>Hi :
>
>I want to create a view for a table, When I create the view with a .sql file,
>and run the file the view is created dynamically. On the other hand if
>I create a view from the sqlplus command line, I can create and
>do a describe on the view.
>I do say 'commit work' after I create a view from the .sql file.
>How can I commit the view from the .sql file.
>Please direct emails to geetha_sanjeeviah_at_p-com.com
>
>--Gita
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu Feb 26 1998 - 00:00:00 CST