Home » SQL & PL/SQL » SQL & PL/SQL » updating a view
updating a view [message #184966] Sat, 29 July 2006 02:48 Go to next message
Messages: 4
Registered: July 2006
Location: Tamil Nadu
Junior Member
a view is updatable even if it conbtain a join when the updated columns are from key preserved table?

wat does this mean?
can there be more than one key preserved table in a view and is it that all those columns referenced from the key preserved table in a view are updatable?
Re: updating a view [message #185032 is a reply to message #184966] Sun, 30 July 2006 07:22 Go to previous message
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Key Preserved means one row in the join view matches exactly to one row in one of tables, and this must be guaranteed by a PK or Unique constraint.

If you have two tables with the same Unique or Primary Key and a view that joins them on that key, then theoretically both would be updateable in the view. I've never tried this - I am pretty sure you could update either of them individually; not sure whether you could update them both in the same statement.

Ross Leishman]
Previous Topic: Scheduling the select statement
Next Topic: Sub-partition within the sub-partition
Goto Forum:

Current Time: Tue Jul 25 16:11:42 CDT 2017

Total time taken to generate the page: 0.11935 seconds