OraFAQ Forum: SQL & PL/SQL » More information about the views

Home » SQL & PL/SQL » SQL & PL/SQL » More information about the views

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

More information about the views [message #230921]

Fri, 13 April 2007 06:15

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

Report message to a moderator

Re: More information about the views [message #230928 is a reply to message #230921]

Fri, 13 April 2007 07:03

Michel Cadot
Messages: 68719
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: More information about the views [message #230940 is a reply to message #230921]

Fri, 13 April 2007 08:24

michael_bialik
Messages: 621
Registered: July 2006

Senior Member

Unless it's a "key-preserved" view.

Report message to a moderator

Re: More information about the views [message #230941 is a reply to message #230940]

Fri, 13 April 2007 08:32

Michel Cadot
Messages: 68719
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	help with TRANSLATE function
Next Topic:	purge recyclebin

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 08 18:29:43 CST 2024