p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Oracle (http://p2p.wrox.com/forumdisplay.php?f=105)
-   -   Alter in View (http://p2p.wrox.com/showthread.php?t=22074)

rekha_jsr December 3rd, 2004 07:33 AM

Alter in View
I have created a view of a particular table.
Now I altered the table added a column but the new added column is not added in the previously created view.
should I drop the View and create new view or is there any other way of doing this.
Pl help.


aas December 3rd, 2004 09:17 AM

Other way is not present.
Any view can be altered as "CREATE OR REPLACE VIEW" command or "DROP VIEW" and "CREATE VIEW".

All times are GMT -4. The time now is 11:42 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.