Home » SQL & PL/SQL » SQL & PL/SQL » modifying a view
modifying a view [message #126764] Wed, 06 July 2005 09:24 Go to next message
kavitharaman
Messages: 8
Registered: June 2005
Junior Member
how to modify a view based on multiple tables?

help me plz

RK
Re: modifying a view [message #126768 is a reply to message #126764] Wed, 06 July 2005 09:39 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Give more information.
Re: modifying a view [message #126778 is a reply to message #126764] Wed, 06 July 2005 11:08 Go to previous messageGo to next message
Steve Callan
Messages: 44
Registered: January 2004
Member
create or replace view view_name as
[your code here]
Re: modifying a view [message #126787 is a reply to message #126764] Wed, 06 July 2005 11:37 Go to previous messageGo to next message
somnath1974
Messages: 15
Registered: July 2005
Junior Member
Hi,
A vew based on multiple tables can be updated in case it is an updatabale view. Or else if it not an updatable view you can think of using an INSTEAD OF Triggers to update views.

Please refer to standard Oracle documents for INSTEAD of Triggers.

Regards,
Somnath
Re: modifying a view [message #255536 is a reply to message #126764] Wed, 01 August 2007 02:34 Go to previous messageGo to next message
Raaghav
Messages: 5
Registered: August 2007
Location: INDIA
Junior Member

Hi

You can easily find it oracle black book.

Regards,
Raaghav.
Re: modifying a view [message #255537 is a reply to message #255536] Wed, 01 August 2007 02:50 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think 2 years it is useless to answer to the port.

Regards
Michel
Previous Topic: to_number and ORA-01722 (really interesting)
Next Topic: continuous week number
Goto Forum:
  


Current Time: Sat Dec 10 09:03:48 CST 2016

Total time taken to generate the page: 0.23677 seconds