DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Connect two fields and let them be synchron

  1. #1
    Join Date
    Jun 2005
    Posts
    5

    Question Connect two fields and let them be synchron

    I want to connect one table 's a field to another table's a field in my present database(win2000+oracle8 ),and let these two fields are synchro.
    How should I do ? Can I finish this function by SQL sentences ?

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Can you explain what you mean by "synchro"?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    Use an update trigger on the primary table column which updates the secondary table's column

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width