Home » SQL & PL/SQL » SQL & PL/SQL » alter view (oracle 10g)
alter view [message #389602] Mon, 02 March 2009 22:15 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi,
is it possible to alter an existing view or we have to go for
create or replace view option to modify an existing view?
Re: alter view [message #389603 is a reply to message #389602] Mon, 02 March 2009 22:16 Go to previous messageGo to next message
trivendra
Messages: 211
Registered: October 2007
Location: Phoenix
Senior Member
create or replace view option to modify an existing view


Yes.

[Updated on: Mon, 02 March 2009 22:16]

Report message to a moderator

Re: alter view [message #389604 is a reply to message #389603] Mon, 02 March 2009 22:18 Go to previous message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
thank you
Previous Topic: systimestamp conversion
Next Topic: Bulk Exception
Goto Forum:
  


Current Time: Thu Feb 13 22:09:18 CST 2025