Unix Technical Forum

Key preserved joins

This is a discussion on Key preserved joins within the Oracle Miscellaneous forums, part of the Oracle Database category; --> When a key is preserved on a join (for update), does that mean specifically that it must be a ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database > Oracle Miscellaneous

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-08-2008, 12:17 PM
dean
 
Posts: n/a
Default Key preserved joins

When a key is preserved on a join (for update), does that mean
specifically that it must be a unique key or a primary key? In other
words, am I correct in assuming that there must actually be a key of
either type, and that nothing else will do?

Thanks!

Dean
10g, 9.2i, Windows

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:26 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com