Home » SQL & PL/SQL » SQL & PL/SQL » More information about the views
More information about the views [message #230921] Fri, 13 April 2007 06:15 Go to next message
namrata_bhise
Messages: 18
Registered: October 2006
Location: mumbai
Junior Member
Hi,

I am in some confusion that if we prepare the view with the two or more table. and we insert the row in the view can changes are
reflected in the base table.
and if insert the row in the view, which is prepared from only one table will changes are reflected in the base table.
Regards
namrata
Re: More information about the views [message #230928 is a reply to message #230921] Fri, 13 April 2007 07:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You may or may not insert in a view with a join.
Most likely you can't, you have to create a trigger (an "instead of" trigger) on the view to insert what you want in the correct base tables.

Regards
Michel

Re: More information about the views [message #230940 is a reply to message #230921] Fri, 13 April 2007 08:24 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Unless it's a "key-preserved" view.
Re: More information about the views [message #230941 is a reply to message #230940] Fri, 13 April 2007 08:32 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, this is why I said "Most likely you can't".
In addition, you can see what you can do for each column with the views %_UPDATABLE_COLUMNS.

Regards
Michel
Previous Topic: help with TRANSLATE function
Next Topic: purge recyclebin
Goto Forum:
  


Current Time: Sun Dec 04 08:19:00 CST 2016

Total time taken to generate the page: 0.08092 seconds