Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 474 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

Full site membership is required for this article. Already a full member? Login here.
You currently have a guest membership. You can upgrade to full site membership here (free trial available).

Updating Views That Contain Outer Joins


 Article Abstract:

(Yuli Vasiliev) Since views can provide a different representation of the data that resides within other tables and views, you, in most cases, may find it more suitable to work with views rather than with their base tables. If so, you probably will want to perform all required DML operations directly on views, just as you perform them on standard tables. Generally, Oracle allows you to update, insert, and delete data in views using the same DML operations that you use for tables if there is no ambiguity.

 Read this article...
 Related Articles - For Members.
All Articles By Author

Using SQL Server Joins
Tips for using SQL Server Join Hints
Tips for using views in SQL Server 2005
What is an outer join?
A new way of joining Oracle tables? Why would I want to change?
DB2 Access Paths
SQL Server Views Optimization Tips
Troubleshooting SQL Server Joins
Microsoft SQL Server Nested-Loop Joins



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004